Status | Function | Description |
|---|---|---|
Not started | ||
Not started | ABS | Returns the absolute value of a number. |
Not started | ACOS | Returns the arccosine, or inverse cosine, of a number. |
Not started | ACOSH | Returns the inverse hyperbolic cosine of a number. |
Not started | ACOT | Returns the arccotangent, or inverse cotangent, of a number. |
Not started | ACOTH | Returns the inverse hyperbolic cotangent of a number. |
Not started | ASIN | Returns the arcsine, or inverse sine, of a number. |
Not started | ASINH | Returns the inverse hyperbolic sine of a number. |
Not started | ATAN | Returns the arctangent, or inverse tangent, of a number. |
Not started | ATANH | Returns the inverse hyperbolic tangent of a number. |
Not started | CEILING | Rounds a number up, to the nearest integer or to the nearest multiple of significance. |
Not started | CONVERT | Converts an expression of one data type to another. |
Not started | COS | Returns the cosine of the given angle. |
Not started | COSH | Returns the hyperbolic cosine of a number. |
Not started | COT | Returns the cotangent of an angle specified in radians. |
Not started | COTH | Returns the hyperbolic cotangent of a hyperbolic angle. |
Not started | CURRENCY | Evaluates the argument and returns the result as currency data type. |
Not started | DEGREES | Converts radians into degrees. |
Not started | DIVIDE | Performs division and returns alternate result or BLANK() on division by 0. |
Not started | EVEN | Returns number rounded up to the nearest even integer. |
Not started | EXP | Returns e raised to the power of a given number. |
Not started | FACT | Returns the factorial of a number, equal to the series 1*2*3*...* , ending in the given number. |
Not started | FLOOR | Rounds a number down, toward zero, to the nearest multiple of significance. |
Not started | GCD | Returns the greatest common divisor of two or more integers. |
Not started | INT | Rounds a number down to the nearest integer. |
Not started | ISO.CEILING | Rounds a number up, to the nearest integer or to the nearest multiple of significance. |
Not started | LCM | Returns the least common multiple of integers. |
Not started | LN | Returns the natural logarithm of a number. |
Not started | LOG | Returns the logarithm of a number to the base you specify. |
Not started | LOG10 | Returns the base-10 logarithm of a number. |
Not started | MOD | Returns the remainder after a number is divided by a divisor. The result always has the same sign as the divisor. |
Not started | MROUND | Returns a number rounded to the desired multiple. |
Not started | ODD | Returns number rounded up to the nearest odd integer. |
Not started | PI | Returns the value of Pi, 3.14159265358979, accurate to 15 digits. |
Not started | POWER | Returns the result of a number raised to a power. |
Not started | QUOTIENT | Performs division and returns only the integer portion of the division result. |
Not started | RADIANS | Converts degrees to radians. |
Not started | RAND | Returns a random number greater than or equal to 0 and less than 1, evenly distributed. |
Not started | RANDBETWEEN | Returns a random number in the range between two numbers you specify. |
Not started | ROUND | Rounds a number to the specified number of digits. |
Not started | ROUNDDOWN | Rounds a number down, toward zero. |
Not started | ROUNDUP | Rounds a number up, away from 0 (zero). |
Not started | SIGN | Determines the sign of a number, the result of a calculation, or a value in a column. |
Not started | SIN | Returns the sine of the given angle. |
Not started | SINH | Returns the hyperbolic sine of a number. |
Not started | SQRT | Returns the square root of a number. |
Not started | SQRTPI | Returns the square root of (number * pi). |
Not started | TAN | Returns the tangent of the given angle. |
Not started | TANH | Returns the hyperbolic tangent of a number. |
Not started | TRUNC | Truncates a number to an integer by removing the decimal, or fractional, part of the number. |