Math
57 functions in this section.
| 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 away from zero to the nearest even number. |
| EXP | Returns the mathematical constant e raised to the power of 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 away from zero to the nearest odd number. |
| PI | Returns the mathematical constant pi, π, roughly 3.14159. |
| 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. |
| SERIESSUM | Returns the sum of a power series. |
| 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. |