ABS returns the absolute value of a number.
ACOS returns the inverse trigonometric cosine of a number.
ASIN returns the inverse trigonometric sine of a number.
ATAN returns the inverse trigonometric tangent of a number.
CEILING rounds a number up to the nearest multiple of significance.
COUNTBLANK returns the number of empty cells.
COUNTIF returns the number of cells that meet criteria within a cell range.
EVEN rounds a positive number up to the next even integer and a negative number down to the next even integer.
EXP returns e raised to the power of a number. The constant e has a value of approximately 2.71828182845904.
FACT returns the factorial of a number. Factorials are calculated as 1*2*3*4* ... * .
FLOOR rounds a number down to the nearest multiple of significance.
Rounds a number down to the nearest integer. Negative numbers round down to the integer less than the number.
LN returns the natural logarithm based on the constant e of a number. The constant e has a value of approximately 2.71828182845904.
LOG returns the logarithm of a number to the specified base.
MOD returns the remainder when one integer is divided by another.
ODD rounds a positive number up to the nearest odd integer and a negative number down to the nearest odd integer.
PI returns 3.14159265358979, the value of the mathematical constant PI to 14 decimal places.
POWER returns a number raised to a power.
PRODUCT multiplies all the numbers given as arguments and returns the product.
RAND returns a random number between 0 and 1.
RANDBETWEEN returns a random integer number in a specified range.
ROUND rounds a number to a number of decimal places. This function rounds to the nearest number. See ROUNDDOWN and ROUNDUP for alternatives.
ROUNDDOWN rounds a number down, toward zero, to a certain precision. See ROUNDUP and ROUND for alternatives.
ROUNDUP rounds a number up, away from zero, to a certain precision. See ROUNDDOWN and ROUND for alternatives.
SQRT returns the positive square root of a number.
SUBTOTAL calculates subtotals. If a range already contains subtotals, these are not used for further calculations.
SUM adds all the numbers in a range of cells.
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 truncates a number by removing decimal places.