Use this list of functions as a reference for each mathematical function.

- ABS function

ABS returns the absolute value of a number. - ACOS function

ACOS returns the inverse trigonometric cosine of a number. - ASIN function

ASIN returns the inverse trigonometric sine of a number. - ATAN function

ATAN returns the inverse trigonometric tangent of a number. - CEILING function

CEILING rounds a number up to the nearest multiple of significance. - COUNTBLANK function

COUNTBLANK returns the number of empty cells. - COUNTIF function

COUNTIF returns the number of cells that meet criteria within a cell range. - EVEN function

EVEN rounds a positive number up to the next even integer and a negative number down to the next even integer. - EXP function

EXP returns e raised to the power of a number. The constant e has a value of approximately 2.71828182845904. - FACT function

FACT returns the factorial of a number. Factorials are calculated as 1*2*3*4* ... * . - FLOOR function

FLOOR rounds a number down to the nearest multiple of significance. - INT function

Rounds a number down to the nearest integer. Negative numbers round down to the integer less than the number. - LN function

LN returns the natural logarithm based on the constant e of a number. The constant e has a value of approximately 2.71828182845904. - LOG function

LOG returns the logarithm of a number to the specified base. - MOD function

MOD returns the remainder when one integer is divided by another. - ODD function

ODD rounds a positive number up to the nearest odd integer and a negative number down to the nearest odd integer. - PI function

PI returns 3.14159265358979, the value of the mathematical constant PI to 14 decimal places. - POWER function

POWER returns a number raised to a power. - PRODUCT function

PRODUCT multiplies all the numbers given as arguments and returns the product. - RAND function

RAND returns a random number between 0 and 1. - RANDBETWEEN function

RANDBETWEEN returns a random integer number in a specified range. - ROUND function

ROUND rounds a number to a number of decimal places. This function rounds to the nearest number. See ROUNDDOWN and ROUNDUP for alternatives. - ROUNDDOWN function

ROUNDDOWN rounds a number down, toward zero, to a certain precision. See ROUNDUP and ROUND for alternatives. - ROUNDUP function

ROUNDUP rounds a number up, away from zero, to a certain precision. See ROUNDDOWN and ROUND for alternatives. - SQRT function

SQRT returns the positive square root of a number. - SUBTOTAL function

SUBTOTAL calculates subtotals. If a range already contains subtotals, these are not used for further calculations. - SUM function

SUM adds all the numbers in a range of cells. - SUMIF function

SUMIF adds the cells specified by the given criteria. This function is used to browse a range when you search for a certain value. - TRUNC function

TRUNC truncates a number by removing decimal places.