| ABS | The absolute value, i.e. a number without its sign. |
| ACOS | The arccosine of a number in radians. |
| ACOSH | The inverse hyperbolic cosine of a number. |
| ASIN | The arcsine of a number in radians. |
| ASINH | The inverse hyperbolic sine of a number. |
| ATAN | The arctangent of a number in radians. |
| ATAN2 | The arctangent of the specified x and y co-ordinates in radians. |
| ATANH | The inverse hyperbolic tangent of a number. |
| CEILING | The number rounded up to the nearest integer / significant figure. |
| COMBIN | The number of combinations for a given number of items. |
| COS | The cosine of an angle in radians. |
| COSH | The hyperbolic cosine of a number. |
| DEGREES | The number of degrees given a number of radians. |
| EVEN | The number rounded up to the nearest even integer. |
| EXP | The exponential number raised to a particular power. |
| FACT | The factorial of a number. |
| FACTDOUBLE* | The double factorial of a number. |
| FLOOR | The number rounded down to the nearest integer or significant figure. |
| GCD* | The greatest common divisor of two or more integers. |
| INT | The number rounded down to the nearest integer. |
| LCM* | The least common multiple of integers. |
| LN | The natural logarithm of a number. |
| LOG | The logarithm of a number to a given base. |
| LOG10 | The logarithm of a number to the base 10. |
| MDETERM | The matrix determinant of an array. |
| MINVERSE | The inverse matrix of an array. |
| MMULT | The matrix product of two arrays. |
| MOD | The remainder after division. |
| MROUND* | The number rounded to the desired multiple. |
| MULTINOMIAL* | The multinomial of a set of numbers in a list of cell range. |
| ODD | The number rounded up to the nearest odd integer. |
| PI | The number PI (3.141592). |
| POWER | The number raised to a given power. |
| PRODUCT | The product of all the numbers in a list or cell range. |
| QUOTIENT* | The integer portion after division. |
| RADIANS | The number of radians given the number of degrees. |
| RAND | The random number between 0 and 1. |
| RANDBETWEEN* | The random number between two specified numbers, inclusively. |
| ROMAN | The text string converting a Binary number to a Roman numeral. |
| ROUND | The number rounded to a specified number of digits. |
| ROUNDDOWN | The number rounded down to the nearest integer. |
| ROUNDUP | The number rounded up to the nearest integer. |
| SERIESSUM* | The sum of a power series based on a formula. |
| SIGN | The numerical value indicating if a number is positive or negative. |
| SIN | The sin of an angle in radians. |
| SINH | The hyperbolic sine of a number. |
| SQRT | The positive square root of a number. |
| SQRTPI* | The square root of a number multiplied by PI. |
| SUBTOTAL | The subtotal of values in a list or database column. |
| SUM | The total value of the numbers in a list or cell range. |
| SUMIF | The total value of the numbers that satisfies a condition. |
| SUMIFS | The total value of the numbers that satisfy multiple conditions. |
| SUMPRODUCT | The sum of the product of one or more arrays of values. |
| SUMSQ | The sum of the squares of all the values in a list or cell range. |
| SUMX2MY2 | The sum of the difference of squares of corresponding values in two arrays. |
| SUMX2PY2 | The sum of the sum of squares of corresponding values in two arrays. |
| SUMXMY2 | The sum of squares of differences of corresponding values in two arrays. |
| TAN | The tangent of an angle in radians. |
| TANH | The hyperbolic tangent of a number. |
| TRUNC | The number with any decimal places removed. |
