No. | Formula | Description |
---|---|---|
1 | SUM | Adds a range of numbers |
2 | AVERAGE | Calculates the average of a range of numbers |
3 | COUNT | Counts the number of cells that contain numbers |
4 | MAX | Returns the largest value in a range of numbers |
5 | MIN | Returns the smallest value in a range of numbers |
6 | ROUND | Rounds a number to a specified number of decimal places |
7 | INT | Rounds a number down to the nearest integer |
8 | ABS | Returns the absolute value of a number |
9 | POWER | Raises a number to a specified power |
10 | SQRT | Returns the square root of a number |
11 | LOG | Returns the logarithm of a number using a specified base |
12 | EXP | Returns e raised to the power of a specified number |
13 | SIN | Returns the sine of an angle |
14 | COS | Returns the cosine of an angle |
15 | TAN | Returns the tangent of an angle |
16 | PI | Returns the value of pi (3.14159265358979) |
17 | RADIANS | Converts degrees to radians |
18 | DEGREES | Converts radians to degrees |
19 | SUMPRODUCT | Calculates the sum of the products of corresponding arrays |
20 | MOD | Returns the remainder after division |