Mathematical and Financial Functions
Use mathematical and financial functions to perform simple and complex calculations, such as future value or logarithmic calculations.
Function |
Description |
Returns the absolute value of a numeric expression. |
|
Returns the arithmetic mean of a range of cells or a sum group. |
|
Returns the total of all cells assigned to a sum group. |
|
Returns the total of all cells assigned to table specific sum group. |
|
Returns the number of columns in the first table found with the specified table name. |
|
Returns the number of cells in a range that meet a specified criteria. |
|
Calculates the exponent of an expression. |
|
Calculates the future value factor of a cash flow. |
|
Returns the base 10 logarithm of an expression. |
|
Returns the maximum value of several expressions. |
|
Returns the middle value from a range of cells or a sum group. |
|
Returns the smallest value of several expressions. |
|
Converts any format to decimal. |
|
Converts any format to integer. |
|
Returns the remainder when one number is divided by another. |
|
Returns a value if value is positive, otherwise returns zero. |
|
Calculates the present value factor of an expected cash flow. |
|
Returns the value of a cell relative to the current cell. |
|
Calculates the ratio between two cells. |
|
Returns the value in a table cell in the same row as but different column from the current cell. |
|
Returns a number rounded to the nearest integer when "Apply Rounding" is in effect. |
|
Returns the value in a table cell that is relatively positioned by column and row to the current cell. |
|
Calculates the total of a range of cells across table columns relative to the current cell |
|
Returns a value rounded by the specified rounding factor. |
|
Returns the number of rows in the first table found with the specified table name. |
|
Returns the value in a table cell in the same column as but different row from the current cell. |
|
Calculates the total of a range of cells across table rows relative to the current cell |
|
Returns the standard deviation of the numbers contained in a range of cells or a sum group. |
|
Calculates the sum of a range of cell values. |
|
Finds the sum of a range of cell values. |