Module math 

Math formula functions: SUMIF, SUMIFS, ROUNDUP, ROUNDDOWN, CEILING, FLOOR, SIGN, RAND, RANDBETWEEN, PI, LOG, LOG10, LN, EXP, PRODUCT, QUOTIENT, FACT.

Functions

fn_ceiling

CEILING(number, significance) - round up to nearest multiple of significance

fn_exp

EXP(number) - e raised to the power of number

fn_fact

FACT(number) - factorial of a non-negative integer

fn_floor

FLOOR(number, significance) - round down to nearest multiple of significance

fn_ln

LN(number) - natural logarithm

fn_log

LOG(number, [base]) - logarithm with optional base (default 10)

fn_log10

LOG10(number) - base-10 logarithm

fn_pi

PI() - returns the value of pi

fn_product

PRODUCT(args…) - product of all numbers

fn_quotient

QUOTIENT(numerator, denominator) - integer part of a division

fn_rand

RAND() - random number between 0 (inclusive) and 1 (exclusive)

fn_randbetween

RANDBETWEEN(bottom, top) - random integer in [bottom, top]

fn_rounddown

ROUNDDOWN(number, digits) - round toward zero (truncate)

fn_roundup

ROUNDUP(number, digits) - round away from zero

fn_sign

SIGN(number) - returns -1, 0, or 1

fn_sumif

SUMIF(range, criteria, [sum_range])

fn_sumifs

SUMIFS(sum_range, criteria_range1, criteria1, …)