Formula Functions

This section defines the mathematical functions available for creating formulas for form formula rows and columns. To insert formula rows and columns in forms, see Adding Formula Rows and Columns.

The syntax for mathematical functions:

FunctionName(arguments)

For more information about arguments, see Arguments.

Table B-1 Mathematical Function Syntax

Variable	Description
FunctionName	The name of a mathematical function
arguments	A numeric value, a row, column, or cell reference, or an embedded function

Mathematical Functions

Table B-2 Mathematical Functions

Function	Description
Abs	Returns the absolute value of numeric values or references. See Abs.
Average	Returns the average of a group of numeric values or references. See Average.
AverageA	Returns the average of a group of numeric values or references. The calculation includes #MISSING cells only for rows or columns that are not suppressed. See AverageA.
Count	Returns the number of values in a group of numeric values or references. See Count.
CountA	Returns the number of values in a group of numeric values or references. The calculation includes #MISSING cells only for rows or columns that are not suppressed. See CountA.
Difference	Returns the absolute value of a numeric value or reference subtracted from another numeric value or reference. See Difference.
Eval	Evaluates an expression. Eval is useful for embedding expressions as function arguments. See Eval.
IfThen, If	Returns one value if a condition equals true, and another value if a specified condition equals false. See IfThen, If.
Max	Returns the maximum value from a group of numeric values or references. See Max.
Min	Returns the minimum value from a group of numeric values or references. See Min.
Mod	Returns the remainder, modulus, from a division formula. See Mod.
PercentOfTotal	Returns the result of a numeric value or reference divided by another numeric value or reference, multiplied by 100. See PercentOfTotal.
Pi	Returns the number 3.14159265358979, to 15 digits. See Pi.
Product	Multiplies all numbers or references and returns the product. See Product.
Random	Returns a random number between 0.0 and 1.0. See Random.
Round	Rounds a number up or down by specified digits. See Round.
Sqrt	Returns the square root of a numeric value, row, column, or cell. See Sqrt.
Sum	Returns the sum of a group of numeric values or references. See Sum.
Truncate / Trunc	Removes the specified number of digits from numeric values. See Truncate/Trunc.
Variance / Var	Evaluates the difference between the specified values based on the account type for the current account. See Variance/Var.
VariancePercent / VarPer	Evaluates the percentage difference between the specified values based on account type for the current account. See VariancePercent/VarPer.