---
title: Math
slug: math
docTags: 
createdAt: 2025-09-22T04:59:56.000Z
---

### ABS

**Description: **Returns the absolute value of a value.

**Example: **

*ABS(number)*

### ACOS

**Description: **Returns the inverse cosine.

**Example: **

*ACOS(number)*

### ACOSH

**Description: **Returns the inverse hyperbolic cosine.

**Example: **

*ACOSH(number)*

### ASIN

**Description: **Returns the inverse sine.

**Example: **

*ASIN(number)*

### ASINH

**Description: **Returns the inverse hyperbolic sine.

**Example: **

*ASINH(number)*

### ATAN

**Description: **Returns the inverse tangent.

**Example: **

*ATAN(number)*

### ATAN2

**Description: **Returns the inverse tangent.

**Example: **

*ATAN2(x\_num,y\_num)*

### ATANH

**Description: **Returns the inverse hyperbolic tangent.

**Example: **

*ATANH(number)*

### AVG

**Description: **Returns the arithmetic mean of the listed arguments.

**Example: **

*AVG(number1, number2,...)*

### CEILING

**Description: **Returns the rounded up value.

**Example: **

*CEILING(number, significance)*

### COMBIN

**Description: **Returns the number of combinations.

**Example: **

*COMBIN(number, number\_chosen)*

### COS

**Description: **Returns the cosine.

**Example: **

*COS(number)*

### COSH

**Description: **Returns the hyperbolic cosine.

**Example: **

*COSH(number)*

### DEGREES

**Description: **Returns the degrees represented by the given radians.

**Example: **

*DEGREES(angle)*

### EVEN

**Description: **Returns the number rounded up to the nearest even integer.

**Example: **

*EVEN(number)*

### EXP

**Description: **Returns the value of e raised to the given argument.

**Example: **

*EXP(number)*

### FACT

**Description: **Returns the factorial of the given value.

**Example: **

*FACT(number)*

### FACTDOUBLE

**Description: **Returns the doublefactorial of the given value.

**Example: **

*FACTDOUBLE(number)*

### Fixed

**Description: **Rounds off to a specified number of decimal places and returns the value in text format.

**Example: **

*Fixed (number, decimal\_places, no\_commas)*

### FLOOR

**Description: **Returns the value rounded down to the nearest value.

**Example: **

*FLOOR(number, significance)*

### GCD

**Description: **Returns the greatest common divisor of two or more given values.

**Example: **

*GCD(number1, numer2, ...)*

### INT

**Description: **Returns the value rounded down to nearest integer.

**Example: **

*INT(number)*

### LCM

**Description: **Returns the least common multiple of two or more given values.

**Example: **

*LCM(number1, number2, ...)*

### LN

**Description: **Returns the natural logarithm of the value.

**Example: **

*LN(number)*

### LOG

**Description: **Returns the logarithm to a given base.

**Example: **

*LOG(number, base)*

### LOG10

**Description: **Returns the logarithm base 10.

**Example: **

*LOG10(number)*

### MOD

**Description: **Returns the remainder after a division.

**Example: **

*MOD(number, divisor)*

### MROUND

**Description: **Rounds a given number up or down to the nearest multiple of a given number

**Example: **

*MROUND(number, multiple)*

### MULTINOMIAL

**Description: **Returns the ratio of the factorial of a sum of values to the product of factorials.

**Example: **

*MULTINOMIAL(number1, (number2), ...)*

### N

**Description: **Converts the given value into a numeric value.

**Example: **

*N(value)*

### ODD

**Description: **Returns the value to the nearest odd integer.

**Example: **

*ODD(number)*

### PI

**Description: **Returns the pi.

**Example: **

*PI( )*

### Pow

**Description: **Returns the value of one number raised to another number.

**Example: **

*POW(number, power)*

### POWER

**Description: **Returns the result of a number raised to a power.

**Example: **

*POWER(number, power)*

### PRODUCT

**Description: **Returns the product of the listed values.

**Example: **

*PRODUCT(number1, number2, ...)*

### QUOTIENT

**Description: **Returns the integer portion of a division between two given numbers.

**Example: **

*QUOTIENT(numerator, denominator)*

### RADIANS

**Description: **Returns the radians from given degrees.

**Example: **

*RADIANS(angle)*

### RAND

**Description: **Returns a random value.

**Example: **

*RAND( )*

### RANDBETWEEN

**Description: **Returns a random number that is between the given ranges.

**Example: **

*RANDBETWEEN(start\_num, end\_num)*

### ROMAN

**Description: **Converts an Arabic number to a Roman numeral.

**Example: **

*ROMAN(number, (form))*

### ROUND

**Description: **Returns the number to a specified number of digits.

**Example: **

*ROUND(number, num\_digits)*

### ROUNDDOWN

**Description: **Returns the number rounded down.

**Example: **

*ROUNDDOWN(number, num\_digits)*

### ROUNDUP

**Description: **Returns the number rounded up.

**Example: **

*ROUNDUP(number, num\_digits)*

### SIGN

**Description: **Returns the sign of the number.

**Example: **

*SIGN(number)*

### SIN

**Description: **Returns the sine of the given angle.

**Example: **

*SIN(number)*

### SinH

**Description: **Returns the hyperbolic sine.

**Example: **

*SinH(value)*

### SQRT

**Description: **Returns the square root of a number.

**Example: **

*SQRT(number)*

### SQRTPI

**Description: **Returns the square root of a given number multiplied by pi.

**Example: **

*SQRTPI(number)*

### SUBTOTAL

**Description: **Returns a subtotal in a list

**Example: **

*SUBTOTAL(function\_Number, ref1, (ref2), ...)*

### Sum

**Description: **Returns the sum of the listed values.

**Example: **

*Sum(number1, number2, ... number\_n)*

### SumIf

**Description: **Returns the conditional sum of the listed values.

**Example: **

*SumIf(range, criteria, sum\_range)*

### SumIfs

**Description: **Sums the values in a given array that satisfy a set of given criteria

**Example: **

*SumIfs(sum\_range, criteria\_range1, criteria1, \[criteria\_range2, criteria2], ...)*

### SUMPRODUCT

**Description: **Returns the sum of the products.

**Example: **

*SUMPRODUCT(array1, array2, array3, ...)*

### SUMSQ

**Description: **Returns the sum of the squares.

**Example: **

*SUMSQ(number1, number2, ...)*

### SUMX2MY2

**Description: **Returns the differences of the squares.

**Example: **

*SUMX2MY2(array\_x, array\_y)*

### SUMX2PY2

**Description: **Returns the sum of the squares.

**Example: **

*SUMX2PY2(array\_x, array\_y)*

### SumXmY2

**Description: **Returns the squares of the differences.

**Example: **

*SumXmY2(array1, array2)*

### TAN

**Description: **Returns the tangent.

**Example: **

*TAN(number)*

### TANH

**Description: **Returns the hyperbolic tangent.

**Example: **

*TANH(number)*

### TRUNC

**Description: **Returns the number without a fractional part.

**Example: **

*TRUNC(number, num\_digits)*