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.