| Function | Description |
|---|---|
| ABS() | This function returns the absolute value of a number. It therefore returns the number, if it is positive, or the opposite (positive) if it is negative |
| ODD(value) | Rounds a number up to the nearest odd integer |
| MOD(value1; value2) | Returns the remainder from division of value1 by value2. |
| EVEN(value) | Rounds a number up to the nearest even integer. |
| CEILING() | Rounds a number to the nearest integer equal to or greater than the value in parenthesis |
| FLOOR() | Rounds a number to the nearest integer equal to or less than the value in parenthesis |
| PRODUCT(value1; value2; etc.) | Returns the product of the multiplication of the values in parenthesis. |
| SUM(value1; value2; etc.) | Returns the sum of the values in parenthesis. |
| SUMSQ(value1; value2; etc.) | Returns the sum of the squares of the arguments. |
| ROUND(value, number) | Rounds the first value to the number of digits indicated by the second number. If the decimal part of the value entered in parenthesis is at least 0.5, the function Math() will round it up to the next whole number. |
| ROUNDDOWN(value, number) | Rounds the first number down to the number of decimal places indicated by the second value. |
| ROUNDUP(value, number) | Rounds the first number up to the number of decimal places indicated by the second value. |
| MAX(Number1; Number2) | Returns the maximum value in the list of arguments. |
| MIN(Number1; Number2) | Returns the minimum value in the list of arguments. |
| POWER(Value1; Value2) | Returns the number Value1 to the power Value2 |
| RAND() | The function RAND() returns a pseudo random number between 0 and 1. The value is generated using data from the computer's clock. |
| ROOT(Value) | Returns the square root of the given number |
| TRUNK(value) | Truncates the given number |
| Function | Description |
|---|---|
| EXP(value) | Returns the exponent raised to the power of a given number. |
| FACT(value) | Returns the factorial of the number (1 * 2 * ... * value). |
| LN(value) | Returns the natural logarithm of the number. |
| LOG(value) | Returns the logarithm of the number to a specified base. |
| LOG10(value) | Returns the base-10 logarithm of the number. |
| Function | Description |
|---|---|
| PI() | Returns the value of pi (approximately 3.1415927) accurate to 15 digits |
| SIN(value) | Returns the sine of the given angle (must be written in radians). The returned value is in the interval [-1;1]. |
| ASIN(value) | Returns the arcsine of the number. The returned value must be in the interval [-1;1]. In other cases, the function ASIN() returns the value NaN (Not a Number). |
| SINH(value) | Returns the hyperbolic sine of the number. |
| ASINH(value) | Returns the inverse hyperbolic sine of the number. |
| COS(value) | Returns the cosine of the given angle (must be written in radians). The returned value is in the interval [-1;1]. |
| ACOS(value) | Returns the arccosine of the number. The returned value must be in the interval [-1;1]. In other cases, the function ACOSH() returns the value NaN (Not a Number). |
| COSH(value) | Returns the hyperbolic cosine of the number (must be written in radians). The returned value is in the interval [-1;1]. |
| ACOSH(value) | Returns the inverse hyperbolic cosine of the number. The returned value must be in the interval [-1;1]. In other cases, the function ACOSH() returns the value NaN (Not a Number). |
| TAN(value) | Returns the tangent of the number (must be written in radians). |
| ATAN(value) | Returns the arctangent of the number. The returned value must be in the interval [-1;1]. In other cases, the function ATAN() returns the value NaN (Not a Number). |
| TANH(value) | Returns the hyperbolic tangent of the number. |
| ATANH(value) | Returns the inverse hyperbolic tangent of the number. |
| DEGREES(value) | Converts the number to degrees. The value given must be in radians. |
| RADIANS(value) | Converts the number to radians. The value given must be in degrees. |
Results for Spreadsheets Mathematical Functions
Results for Spreadsheets Mathematical Functions
Results for Spreadsheets Mathematical Functions
Results for Spreadsheets Mathematical Functions
Results for Spreadsheets Mathematical Functions