Column 1  | Title  | Column 2  | 
|---|---|---|
Function  | Description  | |
ABS  | Returns the absolute value of a number  | |
ACOS  | Returns the arccosine of a number  | |
ACOSH  | Returns the inverse hyperbolic cosine of a number  | |
ACOT (2013)  | Returns the arccotangent of a number  | |
ACOTH (2013)  | Returns the hyperbolic arccotangent of a number  | |
AGGREGATE  | Returns an aggregate in a list or database  | |
ARABIC  | Converts a Roman number to Arabic, as a number  | |
ASIN  | Returns the arcsine of a number  | |
ASINH  | Returns the inverse hyperbolic sine of a number  | |
ATAN  | Returns the arctangent of a number  | |
ATAN2  | Returns the arctangent from x- and y-coordinates  | |
ATANH  | Returns the inverse hyperbolic tangent of a number  | |
BASE (2013)  | Converts a number into a text representation with the given radix (base)  | |
CEILING  | Rounds a number to the nearest integer or to the nearest multiple of significance  | |
CEILING.MATH (2013)  | Rounds a number up, to the nearest integer or to the nearest multiple of significance  | |
CEILING.PRECISE  | Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.  | |
COMBIN  | Returns the number of combinations for a given number of objects  | |
COMBINA (2013)  | Returns the number of combinations with repetitions for a given number of items  | |
COS  | Returns the cosine of a number  | |
COSH  | Returns the hyperbolic cosine of a number  | |
COT (2013)  | Returns the cotangent of an angle  | |
COTH (2013)  | Returns the hyperbolic cotangent of a number  | |
CSC (2013)  | Returns the cosecant of an angle  | |
CSCH (2013)  | Returns the hyperbolic cosecant of an angle  | |
DECIMAL (2013)  | Converts a text representation of a number in a given base into a decimal number  | |
DEGREES  | Converts radians to degrees  | |
EVEN  | Rounds a number up to the nearest even integer  | |
EXP  | Returns e raised to the power of a given number  | |
FACT  | Returns the factorial of a number  | |
FACTDOUBLE  | Returns the double factorial of a number  | |
FLOOR  | Rounds a number down, toward zero  | |
FLOOR.MATH (2013)  | Rounds a number down, to the nearest integer or to the nearest multiple of significance  | |
FLOOR.PRECISE  | Rounds a number down to the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded down.  | |
GCD  | Returns the greatest common divisor  | |
INT  | Rounds a number down to the nearest integer  | 
  | 
ISO.CEILING (2013)  | Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance  | |
LCM  | Returns the least common multiple  | |
LET (2021)  | Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula  | |
LN  | Returns the natural logarithm of a number  | |
LOG  | Returns the logarithm of a number to a specified base  | |
LOG10  | Returns the base-10 logarithm of a number  | |
MDETERM  | Returns the matrix determinant of an array  | |
MINVERSE  | Returns the matrix inverse of an array  | |
MMULT  | Returns the matrix product of two arrays  | |
MOD  | Returns the remainder from division  | 
  | 
MROUND  | Returns a number rounded to the desired multiple  | |
MULTINOMIAL  | Returns the multinomial of a set of numbers  | |
MUNIT (2013)  | Returns the unit matrix or the specified dimension  | |
ODD  | Rounds a number up to the nearest odd integer  | |
PERCENTOF (Microsoft 365)  | Sums the values in the subset and divides it by all the values  | |
PI  | Returns the value of pi  | |
POWER  | Returns the result of a number raised to a power  | |
PRODUCT  | Multiplies its arguments  | |
QUOTIENT  | Returns the integer portion of a division  | |
RADIANS  | Converts degrees to radians  | |
RAND  | Returns a random number between 0 and 1  | |
RANDARRA (2021)  | Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values.  | |
RANDBETWEEN  | Returns a random number between the numbers you specify  | 
  | 
ROMAN  | Converts an Arabic numeral to Roman, as text  | |
ROUND  | Rounds a number to a specified number of digits  | 
  | 
ROUNDDOWN  | Rounds a number down, toward zero  | |
ROUNDUP  | Rounds a number up, away from zero  | |
SEC (2013)  | Returns the secant of an angle  | |
SECH (2013)  | Returns the hyperbolic secant of an angle  | |
SERIESSUM  | Returns the sum of a power series based on the formula  | |
SEQUENCE(2021)  | Generates a list of sequential numbers in an array, such as 1, 2, 3, 4  | |
SIGN  | Returns the sign of a number  | |
SIN  | Returns the sine of the given angle  | |
SINH  | Returns the hyperbolic sine of a number  | |
SQRT  | Returns a positive square root  | |
SQRTPI  | Returns the square root of (number * pi)  | |
SUBTOTAL  | Returns a subtotal in a list or database  | |
SUM  | Adds its arguments  | |
SUMIF  | Adds the cells specified by a given criteria  | 
  | 
SUMIFS (2019)  | Adds the cells in a range that meet multiple criteria  | 
  | 
SUMPRODUCT  | Returns the sum of the products of corresponding array components  | |
SUMSQ  | Returns the sum of the squares of the arguments  | |
SUMX2MY2  | Returns the sum of the difference of squares of corresponding values in two arrays  | |
SUMX2PY2  | Returns the sum of the sum of squares of corresponding values in two arrays  | |
SUMXMY2  | Returns the sum of squares of differences of corresponding values in two arrays  | |
TAN  | Returns the tangent of a number  | |
TANH  | Returns the hyperbolic tangent of a number  | |
TRUNC  | Truncates a number to an integer  |