# 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. |