# Math and Trig Functions

### TRUNC

Truncates a number to an integer by removing the decimal, or fractional, part of the …

### SUMX

Returns the sum of an expression evaluated for each row in a table.

### SUM

Adds all the numbers in a column.

### SQRT

Returns the square root of a number.

### SIGN

Determines the sign of a number, the result of a calculation, or a value in …

### ROUNDUP

Rounds a number up, away from 0 (zero).

### LCM

Returns the least common multiple of integers. The least common multiple is the smallest positive …

### ISO.CEILING

Rounds a number up, to the nearest integer or to the nearest multiple of significance.

### LN

Returns the natural logarithm of a number. Natural logarithms are based on the constant e …

### LOG

Returns the logarithm of a number to the base you specify.

### LOG10

Returns the base-10 logarithm of a number.

### MROUND

Returns a number rounded to the desired multiple.

### ODD

Returns number rounded up to the nearest odd integer.

### PI

Returns the value of Pi, 3.14159265358979, accurate to 15 digits.

### POWER

Returns the result of a number raised to a power.

### PRODUCT

Returns the product of the numbers in a column.

### PRODUCTX

Returns the product of an expression evaluated for each row in a table.

### QUOTIENT

Performs division and returns only the integer portion of the division result. Use this function …

### RAND

Returns a random number greater than or equal to 0 and less than 1, evenly …

### RANDBETWEEN

Returns a random number in the range between two numbers you specify.

### ROUND

Rounds a number to the specified number of digits.

### ROUNDDOWN

Rounds a number down, toward zero.

### INT

Rounds a number down to the nearest integer.

### GCD

Returns the greatest common divisor of two or more integers. The greatest common divisor is …

### FLOOR

Rounds a number down, toward zero, to the nearest multiple of significance.

### ACOS

Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose …

### ABS

Returns the absolute value of a number.

### ACOSH

Returns the inverse hyperbolic cosine of a number. The number must be greater than or …

### ACOT

Returns the principal value of the arccotangent, or inverse cotangent of a number.

### ACOTH

Returns the inverse hyperbolic cotangent of a number.

### ASIN

Returns the arcsine, or inverse sine, of a number. The arcsine is the angle whose …

### ASINH

Returns the inverse hyperbolic sine of a number. The inverse hyperbolic sine is the value …

### ATAN

Returns the arctangent, or inverse tangent, of a number. The arctangent is the angle whose …

### ATANH

Returns the inverse hyperbolic tangent of a number. Number must be between -1 and 1 …

### CEILING

Rounds a number up, to the nearest integer or to the nearest multiple of significance.

### COMBIN

Returns the number of combinations for a given number of items. Use COMBIN to determine …

### COMBINA

Returns the number of combinations (with repetitions) for a given number of items.

### COS

Returns the cosine of the given angle.

### COSH

Returns the hyperbolic cosine of a number.

### CURRENCY

Evaluates the argument and returns the result as currency data type.

### DIVIDE

Performs division and returns alternate result or BLANK() on division by 0.

### EVEN

Returns number rounded up to the nearest even integer. You can use this function for …

### EXP

Returns e raised to the power of a given number. The constant e equals 2.71828182845904, …

### FACT

Returns the factorial of a number, equal to the series 1*2*3*...* , ending in the …