ABS

Returns the absolute value of the parameter.

AVG or AVERAGE

Returns the average of a set of numbers from a variable number of parameters.

IF

Allows for conditional logic to determine if a calculation will execute based on the criteria in the statement.

MAX

Returns the maximum number from a set of numbers (from a variable number of parameters)

MIN

Returns the minimum number from a set of numbers (from a variable number of parameters)

MOD

Returns the modulus (integer remainder) resulting from the division of two numbers.

ROUND

Rounds to the nearest whole number.

ROUNDDOWN

Rounds down to the nearest whole number.

ROUNDUP

Rounds up to the nearest whole number.

SQRT

Returns the square root of a value or numeric parameter.

SIGN

Returns 1 if the parameter is positive, -1 otherwise

SUM

Takes a variable number of parameters and provides a sum total.

TRIM or TRUNC

Truncates the decimal places of a parameter value.