Learn Blog Pricing About Sign in

Learn

Blog

Pricing

About

Sign in

Math functions

ABS Returns the absolute value of a number.
ARABIC Returns an Arabic numeral converted from a Roman numeral.
BASE Returns a text representation of a number converted to a certain base (radix).
CEILING Returns a number rounded up to the nearest multiple of another number.
CEILING.MATH Returns a number rounded up to the nearest multiple of another number.
COMBIN Returns the number of combinations for a certain number of items.
COMBINA Returns the number of combinations with repetitions for a certain number of items.
DECIMAL Converts a textual representation of a number in a given base to a decimal number.
DEGREES Converts the angle given in radians to degrees.
EVEN Rounds a given number up to the nearest even number.
EXP Returns the mathematical constant e raised to a given number.
FACT Returns the factorial of a number, denoted n!.
FACTDOUBLE Returns the double factorial of a number, denoted n!!.
FLOOR Returns a number rounded down to the nearest multiple of another number.
FLOOR.MATH Returns a number rounded down to the nearest multiple of another number.
GCD Returns the greatest common divisor of a set of numbers.
INT Returns a truncated version of a number, in effect rounding it down to the nearest integer.
LCM Returns the least common multiple of a set of numbers.
LN Returns the natural logarithm of a number (using Euler's number — the mathematical constant e—as its base).
LOG Returns the logarithm of a number using a custom base.
LOG10 Returns the base 10 logarithm of a number.
MDETERM Returns the matrix determinant of the given matrix.
MINVERSE Returns the inverse matrix of the given matrix.
MMULT Returns the matrix product of the given matrices.
MOD Returns the remainder after an integer division operation.
MROUND Returns a number rounded to a multiple of another number.
MULTINOMIAL Returns the factorial of the sum of a set of numbers divided by the product of the factorials of the same numbers.
MUNIT Returns the unit matrix for the given dimension.
ODD Rounds a given number up to the nearest odd number.
PI Returns the mathematical constant pi, π.
POWER Raises a number to the power of another number.
PRODUCT Returns the product of the provided values (multiplied together).
PRODUCTIF Returns the product of the array elements that satisfy a condition (multiplying them together).
PRODUCTIFS Returns the product of all array elements which satisfy one or several conditions (multiplying them together).
QUOTIENT Returns the integer (whole number) portion of a division.
RADIANS Converts the angle given in degrees to radians.
RAND Returns a random number between 0 (inclusive) and 1 (exclusive).
RANDARRAY Returns an array with random numbers.
RANDBETWEEN Returns a random integer (whole number) between two given numbers.
ROMAN Returns a Roman number converted from an Arabic numeral.
ROUND Returns a number rounded to a certain precision.
ROUNDDOWN Returns a number rounded down to a certain precision.
ROUNDUP Returns a number rounded up to a certain precision.
SEQUENCE Returns an array containing a sequence of numbers.
SIGN Returns 0 if a number is zero, -1 if it is negative and 1 if it is positive.
SQRT Returns the square root of a number.
SQRTPI Returns the square root of a number multiplied by pi, π.
SUM Returns the sum of the provided values (added together).
SUMIF Returns the sum of the array elements that satisfy a condition (adding them together).
SUMIFS Returns the sum of all array elements which satisfy one or several conditions (adding them together).
SUMPRODUCT Multiplies all the given arrays together and returns the sum of products.
SUMSQ Squares a set of numbers and returns the sum of all squares.
SUMX2MY2 Returns the sum of the differences between the corresponding squared elements of the given two arrays.
SUMX2PY2 Returns the sum of the squares of all elements of the given two arrays.
SUMXMY2 Returns the sum of the squared differences between the corresponding elements of the given two arrays.
TRUNC Returns a number truncated to a certain precision.