menu

Supported Excel Functions

Overview

Math and statistical functions

MAX(), MAXIFS(), MIN(), MINIFS(), SUM(), SUMIF(), SUMIFS(), AVERAGE(), AVERAGEIFS(), MEDIAN(), MODE(), RANK.EQ(), and RANK.AVG() functions support only NUMERIC parameters. If at least one of their parameters is detected as non-NUMERIC at compile time, it results in an error. If all arguments of the MAX(), MAXIFS(), MIN(), MINIFS(), SUM(), SUMIF(), SUMIFS() are absent these functions return a zero. The AVERAGE() and AVERAGEIFS() function does not count the absent parameters.

Logical Functions

These functions support only BOOLEAN parameters. If at least one of the parameters is detected as non-BOOLEAN at compile time, it results in an error. An absent parameter is considered false. The OR() and AND() functions require that at least one parameter is present.

Other functions

There are no special considerations.