You are here: Features > Cell Functions > Mathematical and Financial Functions > Mathematical and Financial Functions

Mathematical and Financial Functions

Use mathematical and financial functions to perform simple and complex calculations, such as future value or logarithmic calculations.

Function

Description

ABS

Returns the absolute value of a numeric expression.

AVERAGE

Returns the arithmetic mean of a range of cells or a sum group.

CGROUP

Returns the total of all cells assigned to a sum group.

CGROUPT

Returns the total of all cells assigned to table specific sum group.

COLCOUNT

Returns the number of columns in the first table found with the specified table name.

COUNTIF

Returns the number of cells in a range that meet a specified criteria.

EXP

Calculates the exponent of an expression.

FV

Calculates the future value factor of a cash flow.

LOG

Returns the base 10 logarithm of an expression.

MAX

Returns the maximum value of several expressions.

MEDIAN

Returns the middle value from a range of cells or a sum group.

MIN

Returns the smallest value of several expressions.

MKDEC

Converts any format to decimal.

MKINT

Converts any format to integer.

MOD

Returns the remainder when one number is divided by another.

POS

Returns a value if value is positive, otherwise returns zero.

PV

Calculates the present value factor of an expected cash flow.

R

Returns the value of a cell relative to the current cell.

RATIO

Calculates the ratio between two cells.

RC

Returns the value in a table cell in the same row as but different column from the current cell.

RCNV

Returns a number rounded to the nearest integer when "Apply Rounding" is in effect.

RCR

Returns the value in a table cell that is relatively positioned by column and row to the current cell.

RCTOTAL

Calculates the total of a range of cells across table columns relative to the current cell

ROUND

Returns a value rounded by the specified rounding factor.

ROWCOUNT

Returns the number of rows in the first table found with the specified table name.

RR

Returns the value in a table cell in the same column as but different row from the current cell.

RRTOTAL

Calculates the total of a range of cells across table rows relative to the current cell

STDDEV

Returns the standard deviation of the numbers contained in a range of cells or a sum group.

SUM

Calculates the sum of a range of cell values.

TOTAL

Finds the sum of a range of cell values.

Related Topics