Most Useful Excel 10 Maths Formulas with Example

Mathematical Formula

Microsoft Excel offers many built-in mathematical functions that can significantly simplify complex calculations and data analysis. The 10 most useful Excel math formulas can help users with various tasks, such as finding totals and averages and performing calculations. These formulas are simple to use and can be customized to work with different datasets.

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).