| Function |
Description |
|---|---|
| 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 arctangent of a number. |
| ATAN2 |
Returns the arctangent from x- and y-coordinates. |
| ATANH |
Returns the inverse hyperbolic tangent of a number. |
| CEILING |
Rounds a number to the nearest integer or to the nearest multiple of significance. |
| COMBIN |
Returns the number of combinations for a given number of objects. |
| COS |
Returns the cosine of a number. |
| COSH |
Returns the hyperbolic cosine of a number. |
| DEGREES |
Converts radians to degrees. |
| EVEN |
Rounds a number up to the nearest even integer. |
| EXP |
Returns e raised to the power of a given number. |
| FACT |
Returns the factorial of a number. |
| FLOOR |
Rounds a number down, toward zero. |
| INT |
Rounds a number down to the nearest integer. |
| LN |
Returns the natural logarithm of a number. |
| LOG |
Returns the logarithm of a number to a specified base. |
| LOG10 |
Returns the base-10 logarithm of a number. |
| MOD |
Returns the remainder from division. |
| ODD |
Rounds a number up to the nearest odd integer. |
| PI |
Returns the value of pi. |
| POWER |
Returns the result of a number raised to a power. |
| PRODUCT |
Multiplies its arguments. |
| RADIANS |
Converts degrees to radians. |
| RAND |
Returns a random number between 0 and 1. |
| ROMAN |
Converts an arabic numeral to roman, as text. |
| ROUND |
Rounds a number to a specified number of digits. |
| ROUNDDOWN |
Rounds a number down, toward zero. |
| ROUNDUP |
Rounds a number up, away from zero. |
| SIGN |
Returns the sign of a number. |
| SIN |
Returns the sine of the given angle. |
| SINH |
Returns the hyperbolic sine of a number. |
| SQRT |
Returns a positive square root. |
| SUM |
Adds its arguments. |
| SUMIF |
Adds the cells specified by a given criteria. |
| SUMPRODUCT |
Returns the sum of the products of corresponding array components. |
| TAN |
Returns the tangent of a number. |
| TANH |
Returns the hyperbolic tangent of a number. |