Math and Trigonometry Functions
ABS function
The ABS function returns the absolute value of a number (the number without its sign).
ACOS function
The ACOS function returns the arccosine of a number.
ACOSH function
The ACOSH function returns the inverse hyperbolic cosine of a number.
ACOT function
The ACOT function returns the principal value of the arccotangent, or inverse cotangent, of a number.
ACOTH function
The ACOTH function returns the inverse hyperbolic cotangent of a number.
AGGREGATE function
The AGGREGATE function returns an aggregate in a list or database, with the option to ignore hidden rows and error values.
ARABIC function
The ARABIC function converts a Roman numeral to an Arabic numeral.
ASIN function
The ASIN function returns the arcsine of a number.
ASINH function
The ASINH function returns the inverse hyperbolic sine of a number.
ATAN function
The ATAN function returns the arctangent of a number.
ATAN2 function
The ATAN2 function returns the arctangent of x and y coordinates.
ATANH function
The ATANH function returns the inverse hyperbolic tangent of a number.
BASE function
Converts a number into a text representation with the given base.
CEILING function
Rounds a number up to the nearest multiple of significance.
CEILING.MATH function
Rounds a number up to the nearest integer or to the nearest multiple of significance.
CEILING.PRECISE function
Returns a number rounded up to the nearest integer or to the nearest multiple of significance, regardless of its sign.
COMBIN function
Returns the number of combinations for a specified number of items.
COMBINA function
Returns the number of combinations (with repetitions) for a given number of items.
COS function
Returns the cosine of an angle.
COSH function
Returns the hyperbolic cosine of a number.
COT function
Returns the cotangent of an angle specified in radians.
COTH function
Returns the hyperbolic cotangent of a hyperbolic angle.
CSC function
Returns the cosecant of an angle specified in radians.
CSCH function
Returns the hyperbolic cosecant of an angle specified in radians.
DECIMAL function
Convert a text representation of a number in a given base into a decimal number.
DEGREES function
Convert radians into degrees.
ECMA.CEILING function
Round a number up to the nearest multiple of significance, with negative numbers rounded towards zero.
EVEN function
Round a number up to the nearest even integer.
EXP function
Return the e constant raised to the desired power.
FACT function
Return the factorial of a number.
FACTDOUBLE function
Return the double factorial of a number.
FLOOR function
Round a number down to the nearest multiple of significance.
FLOOR.PRECISE function
Return a number rounded down to the nearest integer or to the nearest multiple of significance, regardless of its sign.
FLOOR.MATH function
Round a number down to the nearest integer or to the nearest multiple of significance.
GCD function
Return the greatest common divisor of two or more numbers.
INT function
Analyze and return the integer part of the specified number.
ISO.CEILING function
Round a number up to the nearest integer or to the nearest multiple of significance, regardless of its sign.
LCM function
Return the lowest common multiple of one or more numbers.
LN function
Return the natural logarithm of a number.
LOG function
Return the logarithm of a number to a specified base.
LOG10 function
Return the logarithm of a number to a base of 10.
MDETERM function
Return the matrix determinant of an array.
MINVERSE function
Return the inverse matrix for a given matrix and display the first value of the returned array of numbers.
MMULT function
Return the matrix product of two arrays and display the first value of the returned array of numbers.
MOD function
Return the remainder after the division of a number by the specified divisor.
MROUND function
Round a number to the desired multiple.
MULTINOMIAL function
Return the ratio of the factorial of a sum of numbers to the product of factorials.
MUNIT function
Return the unit matrix for the specified dimension.
ODD function
Round a number up to the nearest odd integer.
PI function
Return the mathematical constant pi, equal to 3.14159265358979.
POWER function
Return the result of a number raised to the desired power.
PRODUCT function
Multiply all the numbers in the selected range of cells and return the product.
QUOTIENT function
Return the integer portion of a division.
RADIANS function
Convert degrees into radians.
RAND function
Return a random number greater than or equal to 0 and less than 1.
RANDARRAY function
Return an array of random numbers with a given number of rows and columns, value range and whole or decimal numbers.
RANDBETWEEN function
Return a random number between the specified lower and upper bounds.
ROMAN function
Convert a number to a roman numeral.
ROUND function
Round a number to the desired number of digits.
ROUNDDOWN function
Round a number down to the desired number of digits.
ROUNDUP function
Round a number up to the desired number of digits.
SEC function
Return the secant of an angle specified in radians.
SECH function
Return the hyperbolic secant of an angle specified in radians.
SERIESSUM function
Return the sum of a power series.
SEQUENCE function
Generate an array of sequential numbers.
SIGN function
Return the sign of a number.
SIN function
Return the sine of an angle.
SINH function
Return the hyperbolic sine of a number.
SQRT function
Return the square root of a number.
SQRTPI function
Return the square root of the pi constant multiplied by a number.
SUBTOTAL function
Return a subtotal in a list or database.
SUM function
Add all the numbers in a range of cells and return the result.
SUMIF function
Add all the numbers in a range of cells based on the specified criterion and return the result.
SUMIFS function
Add all the numbers in a range of cells based on multiple criteria and return the result.
SUMPRODUCT function
Multiply the values in the selected ranges of cells or arrays and return the sum of the products.
SUMSQ function
Add the squares of numbers and return the result.
SUMX2MY2 function
Sum the difference of squares between two arrays.
SUMX2PY2 function
Sum the squares of numbers in the selected arrays and return the sum of the results.
SUMXMY2 function
Return the sum of the squares of the differences between corresponding items in the arrays.
TAN function
Return the tangent of an angle.
TANH function
Return the hyperbolic tangent of a number.
TRUNC function
Return a number truncated to a specified number of digits.