Most Useful Excel 10 Maths Formulas with Example

Mathematical Formula

1. SUM

Formula:

Description: Adds up all numbers in the range A1 to A5.

Example:
If A1 = 5, A2 = 10, A3 = 15, A4 = 20, A5 = 25, the formula =SUM(A1:A5) will return 75.

---

2. AVERAGE

Formula:

Description: Calculates the average of numbers in the range A1 to A5.

Example:
If A1 = 5, A2 = 10, A3 = 15, A4 = 20, A5 = 25, the formula =AVERAGE(A1:A5) will return 15.

---

3. COUNT

Formula:

Description: Counts the number of cells with numbers in the range A1 to A5.

Example:
If A1 = 5, A2 = “Egyanvani.com”, A3 = 15, A4 = ”, and A5 = 25, the formula =COUNT(A1:A5) will return 3 (counting only the numeric values).

---

4. COUNTA

Formula:

Description: Counts the number of non-empty cells in the range A1 to A5.

Example:
If A1 = 5, A2 = “Egyanvani.com”, A3 = 15, A4 = “”, and A5 = 25, the formula =COUNTA(A1:A5) will return 4 (counting all non-empty cells).

---

5. MAX

Formula:

Description: Returns the maximum value in the range A1 to A5.

Example:
If A1 = 5, A2 = 10, A3 = 15, A4 = 20, A5 = 25, the formula =MAX(A1:A5) will return 25.

---

6. MIN

Formula:

Description: Returns the minimum value in the range A1 to A5.

Example:
If A1 = 5, A2 = 10, A3 = 15, A4 = 20, A5 = 25, the formula =MIN(A1:A5) will return 5.

---

7. PRODUCT

Formula:

Description: Multiplies all numbers in the range A1 to A5.Example:
If A1 = 2, A2 = 3, A3 = 4, A4 = 5, A5 = 6, the formula =PRODUCT(A1:A5) will return 720 (2 * 3 * 4 * 5 * 6).

---

8. SQRT

Formula:

Description: Returns the square root of the number in cell A1.

Example:
If A1 = 16, the formula =SQRT(A1) will return 4.

---

9. POWER

Formula:

Description: Raises the number in cell A1 to the power of 2 (squares the number).

Example:
If A1 = 4, the formula =POWER(A1, 2) will return 16.

---

10. ROUND

Formula:

Description: Rounds the number in A1 to 2 decimal places.

Example:
If A1 = 3.14159, the formula =ROUND(A1, 2) will return 3.14.

---

11. ROUNDUP

Formula:

Description: Rounds the number in A1 up to the nearest integer.

Example:
If A1 = 3.14159, the formula =ROUNDUP(A1, 0) will return 4.

---

12. ROUNDDOWN

Formula:

Description: Rounds the number in A1 down to the nearest integer.Example:
If A1 = 3.14159, the formula =ROUNDDOWN(A1, 0) will return 3.

---

13. IF

Formula:

Description: This formula checks if the value in A1 is greater than 10. If true, it returns “Greater”, otherwise, it returns “Lesser”.

Example:
If A1 = 5, the formula =IF(A1>10, “Greater”, “Lesser”) will return Lesser.

---

14. ABS

Formula:

Description: Returns the absolute value of the number in A1.

Example:
If A1 = -10, the formula =ABS(A1) will return 10.

---

15. MOD

Formula:

Description: Returns the remainder when the number in A1 is divided by 3.

Example:
If A1 = 10, the formula =MOD(A1, 3) will return 1 (since 10 divided by 3 gives the remainder 1).

---