ABS | ABS(number) |
ARABIC | ARABIC( text ) |
ASIN | ASIN(number) |
CEILING | CEILING(number,significance) |
CEILING.MATH | CEILING.MATH(number, [significance], [mode]) |
CEILING.PRECISE | CEILING.PRECISE(number, [significance]) |
COS | COS(number) |
DECIMAL | DECIMAL(text, radix) |
DEGREES | DEGREES(angle) |
EVEN | EVEN(number) |
EXP | EXP(number) |
FACT | FACT(number) |
FLOOR | FLOOR(number,significance) |
FLOOR.MATH | FLOOR.MATH(number, significance, mode) |
FLOOR.PRECISE | FLOOR.PRECISE(number, [significance]) |
GCD | GCD(number1,number2, ...) |
INT | INT(number) |
LCM | LCM(number1,number2, ...) |
LN | LN(number) |
LOG | LOG(number,base) |
LOG10 | LOG10(number) |
MOD | MOD(number,divisor) |
MROUND | MROUND(number,multiple) |
ODD | ODD(number) |
PI | PI( ) |
POWER | POWER(number,power) |
QUOTIENT | QUOTIENT(numerator,denominator) |
RADIANS | RADIANS(angle) |
RAND | RAND( ) |
RANDBETWEEN | RANDBETWEEN(bottom,top) |
ROMAN | ROMAN(number,form) |
ROUND | ROUND(number,num_digits) |
ROUNDDOWN | ROUNDDOWN(number,num_digits) |
ROUNDUP | ROUNDUP(number,num_digits) |
SIGN | SIGN(number) |
SIN | SIN(number) |
SQRT | SQRT(number) |
SUBTOTAL | SUBTOTAL(function_num, ref1, ref2, ...) |
SUM | SUM(number1,number2, ...) |
SUMIF | SUMIF(range,criteria,sum_range) |
SUMIFS | SUMIFS(sum_range,criteria_range1,criteria1,criteria_range2,criteria2…) |
SUMPRODUCT | SUMPRODUCT(array1,array2,array3, ...) |
TAN | TAN(number) |
TRUNC | TRUNC(number,num_digits) |