Mathematics and trigonometric functions are commonly used, and some formulas need to be loaded into the analysis tool library.

Tools-Add-ins-Check Analysis Tool Gallery-OK

ABS returns the absolute value of a number.

ACOS returns the arccosine of a number.

ACOSH returns the inverse hyperbolic cosine of a number.

ASIN returns the arcsine of a number.

ASINH returns the inverse hyperbolic sine of a number.

ATAN returns the arc tangent of a number.

ATAN2 returns arc tangent from x and y coordinates.

ATANH returns the inverse hyperbolic tangent of a number.

CEILING rounds a number to the nearest integer or a multiple of the nearest significant number.

COMBIN returns the combined number of objects of a given number.

COS returns the cosine of a number.

Returns the hyperbolic cosine of a number.

DEGREES converts radians into degrees.

Even numbers round numbers up to the nearest even number.

EXP returns the specified power of e.

FACT returns the factorial of a number.

FACTDOUBLE returns the double factorial of a number.

FLOOR rounds the number down to zero.

GCD returns the greatest common divisor

INT rounds numbers down to the nearest integer.

LCM returns the least common multiple

LN returns the natural logarithm of a number.

LOG returns the logarithm of the specified base of a number.

LOG 10 returns the common logarithm of a number.

MDETERM returns the matrix determinant of an array.

MINVERSE returns the reciprocal of an array.

MMULT returns the matrix product of two arrays.

MOD returns the remainder of dividing two numbers.

MROUND returns a number rounded by a specified multiple.

Polynomial A polynomial that returns a set of numbers.

ODD rounds numbers up to the nearest odd integer.

Pi returns the PI value.

POWER returns the power of a number.

The product is multiplied by all the numbers given as parameters.

Quotient returns the integer part of the quotient.

Radians Converts angles to radians.

RAND returns a random number between 0 and 1.

RANDBETWEEN returns a random number between specified numbers.

ROMAN converts Arabic numerals into Roman numerals in text form.

ROUND rounds a number to the specified number of digits.

ROUNDDOWN rounds the number to zero.

ROUNDUP rounds numbers away from zero.

SERIESSUM returns the sum of power series according to the formula.

SIGN returns the symbol of a number.

SIN returns the sine of a given angle.

SINH returns the hyperbolic sine of a number.

SQRT returns the positive square root.

SQRTPi returns the square root of the product of a number and pi.

SUBTOTAL returns a list of databases or subtotals in a database.

SUM sums the parameters.

SUMIF sums the specified cells according to the given conditions.

SUMPRODUCT returns the product sum of the corresponding array parts.

SUMSQ returns the sum of squares of parameters.

SUMX2MY2 returns the sum of the square differences of the corresponding values in two arrays.

SUMX2PY2 returns the sum of squares of corresponding values in two arrays.

SUMXMY2 returns the sum of squares of the differences between the corresponding values in two arrays.

TAN returns the tangent of a number.

TANH returns the hyperbolic tangent of a number.

TRUNC truncates and rounds numbers.