Mathematical Functions

These functions perform specific mathematical calculations. Mathematical functions define and return values that are based on selected member expressions. These functions cover many basic statistical functions and return numeric results that are based on supplied member values. Advanced statistical functions are included in the statistical functions category.

In the following quick-reference table, words in italics loosely represent information you supply to the function. For details, see the individual function topics.

Table 2-7 Mathematical Functions

Function	Return Value
@ABS	Absolute value of expression.
@AVG	Average of all values in expList.
@EXP	e (base of natural logarithms) raised to the power of expression.
@FACTORIAL	Factorial of expression.
@INT	Next lowest integer value of expression.
@LN	e (base of natural logarithms) of expression.
@LOG	Any base logarithm of expression.
@LOG10	Base-10 logarithm of expression.
@MAX	Maximum value found in cells of an expression list.
@MAXS	Maximum value found in cells of an expression list, optionally skipping empty values.
@MIN	Minimum value found in cells of expression list.
@MINS	Minimum value found in cells of an expression list, optionally skipping empty values.
@MOD	Modulus of a division operation between two members.
@POWER	Expression raised to power.
@REMAINDER	Remainder value of expression.
@ROUND	Expression rounded to numDigits.
@SUM	Sum of values found in cells of an expression list.
@TRUNCATE	Expression with fractional part removed, returning an integer.
@VAR	Variance between two members.
@VARPER	Percent variance between two members.