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