﻿ Math and Trigonometric Functions | SpreadJS 14
Formula Reference / Formula Functions / Math and Trigonometric Functions
In This Topic
Math and Trigonometric Functions
In This Topic

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

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