# Math and Trigonometric Functions

## Content

Spread provides the following math and trigonometric functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [ABS](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ABS) | This function calculates the absolute value of the specified value. |
| [ACOS](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ACOS) | This function calculates the arccosine, that is, the angle whose cosine is the specified value. |
| [ACOSH](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ACOSH) | This function calculates the inverse hyperbolic cosine of the specified value. |
| [ACOT](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ACOT) | This function calculates the inverse arccotangent of a number. |
| [ACOTH](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ACOTH) | This function calculates the inverse hyperbolic arccotangent of a number. |
| [AGGREGATE](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/agrregate) | This function aggregate a list of numbers using a specified built-in function. |
| [ARABIC](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ARABIC) | This function converts a Roman numeral text to an Arabic numeral equivalent. |
| [ASIN](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ASIN) | This function calculates the arcsine, that is, the angle whose sine is the specified value. |
| [ASINH](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ASINH) | This function calculates the inverse hyperbolic sine of a number. |
| [ATAN](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ATAN) | This function calculates the arctangent, that is, the angle whose tangent is the specified value. |
| [ATAN2](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ATAN2) | This function calculates the arctangent of the specified x- and y-coordinates. |
| [ATANH](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ATANH) | This function calculates the inverse hyperbolic tangent of a number. |
| [BASE](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/BASE) | This function converts a number into a text representation with the given radix (base). |
| [CEILING](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/CEILING) | This function rounds a number up to the nearest multiple of a specified value. |
| [MATH](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/CEILING.MATH) | This function rounds a number up to the nearest integer or the nearest multiple of significance. |
| [PRECISE](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/CEILING.PRECISE) | This function rounds a number up to the nearest integer or the nearest multiple of a specified value. |
| [COMBIN](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/COMBIN) | This function calculates the number of possible combinations for a specified number of items. |
| [COMBINA](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/COMBINA) | This function calculates the number of possible combinations with repetitions for a specified number of items. |
| [COS](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/COS) | This function returns the cosine of the specified angle. |
| [COSH](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/COSH) | This function returns the hyperbolic cosine of the specified value. |
| [COT](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/COT) | This function returns the cotangent of the specified angle. |
| [COTH](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/COTH) | This function returns the hyperbolic cotangent of the specified number. |
| [CSC](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/CSC) | This function returns the cosecant of the specified angle. |
| [CSCH](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/CSCH) | This function returns the hyperbolic cosecant of the specified number. |
| [DECIMAL](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/DECIMAL) | This function converts a text representation of a number in a given base into a decimal number. |
| [DEGREES](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/DEGREES) | This function converts the specified value from radians to degrees. |
| [EVEN](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/EVEN) | This function rounds the specified value up to the nearest even integer. |
| [EXACT](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/EXACT) | This function returns true if two strings are the same; otherwise, false. |
| [EXP](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/EXP) | This function returns e raised to the power of the specified value. |
| [FACT](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/FACT) | This function calculates the factorial of the specified number. |
| [FACTDOUBLE](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/FACTDOUBLE) | This function calculates the double factorial of the specified number. |
| [MATH](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/FLOOR.MATH) | This function rounds a number down to the nearest integer or the nearest multiple of significance. |
| [PRECISE](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/FLOOR.PRECISE) | This function rounds a number down to the nearest integer or the nearest multiple of a specified value. |
| [GCD](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/GCD) | This function returns the greatest common divisor of two numbers. |
| [INT](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/INT) | This function rounds a specified number down to the nearest integer. |
| [CEILING](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ISO.CEILING) | This function returns a number up to the nearest integer or the nearest multiple of significance, regardless of the sign of significance. |
| [LCM](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/LCM) | This function returns the least common multiple of two numbers. |
| [LET](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/LET) | This function assigns calculation results to names. Useful for storing intermediate calculations and values by defining names inside a formula. These names only apply within the scope of the LET function. |
| [LN](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/LN) | This function returns the natural logarithm of the specified number. |
| [LOG](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/LOG) | This function returns the logarithm base Y of a number X. |
| [LOG10](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/LOG10) | This function returns the logarithm base 10 of the number given. |
| [MDETERM](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/MDETERM) | This function returns the matrix determinant of an array. |
| [MINVERSE](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/MINVERSE) | This function returns the inverse matrix for the matrix stored in an array. |
| [MMULT](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/MMULT) | This function returns the matrix product for two arrays. |
| [MOD](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/MOD) | This function returns the remainder of a division operation. |
| [MROUND](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/MROUND) | This function returns a number rounded to the desired multiple. |
| [MULTINOMIAL](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/MULTINOMIAL) | This function calculates the ratio of the factorial of a sum of values to the product of factorials. |
| [MUNIT](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/MUNIT) | This function returns the unit matrix for the specified dimension. |
| [ODD](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ODD) | This function rounds the specified value up to the nearest odd integer. |
| [PI](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/PI) | This function returns PI as 3.1415926536. |
| [POWER](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/POWER) | This function raises the specified number to the specified power. |
| [PRODUCT](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/PRODUCT) | This function multiplies all the arguments and returns the product. |
| [QUOTIENT](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/QUOTIENT) | This function returns the integer portion of a division. Use this to ignore the remainder of a division. |
| [RADIANS](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/RADIANS) | This function converts the specified number from degrees to radians. |
| [RAND](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/RAND) | This function returns an evenly distributed random number between 0 and 1. |
| [RANDARRAY](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/randarray) | This function returns an array of random numbers. |
| [RANDBETWEEN](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/RANDBETWEEN) | This function returns a random number between the numbers you specify. |
| [ROMAN](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ROMAN) | This function converts an Arabic numeral to a Roman numeral text equivalent. |
| [ROUND](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ROUND) | This function rounds the specified value to the nearest number, using the specified number of decimal places. |
| [ROUNDDOWN](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ROUNDDOWN) | This function rounds the specified number down to the nearest number, using the specified number of decimal places. |
| [ROUNDUP](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/ROUNDUP) | This function rounds the specified number up to the nearest number, using the specified number of decimal places. |
| [SEC](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SEC) | This function returns the secant of the specified angle. |
| [SECH](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SECH) | This function returns the hyperbolic secant of the specified value. |
| [SEQUENCE](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/sequence) | This function returns the sum of a power series. |
| [SERIESSUM](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SERIESSUM) | This function returns a sequence of numbers. |
| [SIGN](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SIGN) | This function returns the sign of a number or expression. |
| [SIN](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SIN) | This function returns the sine of the specified angle. |
| [SINH](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SINH) | This function returns the hyperbolic sine of the specified number. |
| [SQRT](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SQRT) | This function returns the positive square root of the specified number. |
| [SQRTPI](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SQRTPI) | This function returns the positive square root of a multiple of pi (p). |
| [SUBTOTAL](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SUBTOTAL) | This function calculates a subtotal of a list of numbers using a specified built-in function. |
| [SUM](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SUM) | This function returns the sum of cells or range of cells. |
| [SUMIF](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SUMIF) | This function adds the cells using the given criteria. |
| [SUMIFS](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SUMIFS) | This function adds the cells in a range using multiple criteria. |
| [SUMPRODUCT](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SUMPRODUCT) | This function returns the sum of the products of cells. Multiplies corresponding components in the given arrays, and returns the sum of those products. |
| [SUMSQ](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SUMSQ) | This function returns the sum of the squares of the arguments. |
| [SUMX2MY2](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SUMX2MY2) | This function returns the sum of the difference of the squares of corresponding values in two arrays. |
| [SUMX2PY2](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SUMX2PY2) | This function returns the sum of squares of corresponding values in two arrays. |
| [SUMXMY2](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/SUMXMY2) | This function returns the sum of the square of the differences of corresponding values in two arrays. |
| [TAN](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/TAN) | This function returns the tangent of the specified angle. |
| [TANH](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/TANH) | This function returns the hyperbolic tangent of the specified number. |
| [TRUNC](/spreadjs/docs/v17/formulareference/FormulaFunctions/math-trig-functions/TRUNC) | This function removes the specified fractional part of the specified number. |