| ABS |
Find the absolute value of a number |
number |
| CEILING |
Round a number up to the nearest specified multiple |
number multiple |
| COS |
Get the cosine of an angle |
number |
| DEGREES |
Converts an angle into degrees |
angle |
| EVEN |
Round a number up to the next even integer |
number |
| EXP |
Find the value of e raised to the power of a number |
number |
| FACT |
Find the factorial of a number |
number |
| FLOOR |
Round a number down to the nearest specified multiple |
number multiple |
| GCD |
Get the greatest common divisor of two or more numbers |
number1number2 … |
| INT |
Get the integer part of a decimal by rounding down |
number |
| LCM |
Get the least common multiple or two or more numbers |
number1number2 … |
| LOG10 |
Get the base-10 logarithm of a number |
number |
| MOD |
Get the remainder from division |
number divisor |
| MROUND |
Round a number to the nearest specified multiple |
number multiple |
| ODD |
Round a number up to the next odd integer |
number |
| PI |
Get the value of π |
|
| RADIANS |
Converts an angle into radians |
angle |
| RAND |
Get a random number between 0 and 1 |
|
| RANDBETWEEN |
Get a random integer between two values |
bottom top |
| ROUND |
Round a number to a given number of digits |
number num_digits |
| ROUNDDOWN |
Round a number down to a given number of digits |
number num_digits |
| ROUNDUP |
Round a number up to a given number of digits |
number number_digits |
| SIGN |
Get the sign of a number. |
number |
| SIN |
Get the sine of an angle |
number |
| SQRT |
Find the positive square root of a number |
number |
| SUBTOTAL |
Get a subtotal in a list or database |
function_num ref1ref2 … |
| SUM |
Add numbers together |
number1number2 number3 … |
| SUMIF |
Sum numbers in a range that meet supplied criteria |
range criteriasum_range |
| SUMPRODUCT |
Multiply, then sum arrays |
array1array2 … |
| TAN |
Get the tangent of an angle. |
number |
