Last Updated on
June 26, 2023
Written by
Kori Jagruti
Excel is a powerful tool for data analysis and manipulation, and one of its most useful features is its ability to perform complex mathematical calculations. Here are some of the most commonly used Excel maths formulas:
- SUM: This formula adds up a range of numbers. For example, if you want to add up the values in cells A1 to A10, you would use the formula =SUM(A1:A10).
- AVERAGE: This formula calculates the average of a range of numbers. For example, if you want to calculate the average of the values in cells A1 to A10, you would use the formula =AVERAGE(A1:A10).
- MAX: This formula finds the highest value in a range of numbers. For example, if you want to find the highest value in cells A1 to A10, you would use the formula =MAX(A1:A10).
- MIN: This formula finds the lowest value in a range of numbers. For example, if you want to find the lowest value in cells A1 to A10, you would use the formula =MIN(A1:A10).
- COUNT: This formula counts the number of cells in a range that contain numbers. For example, if you want to count the number of cells in cells A1 to A10 that contain numbers, you would use the formula =COUNT(A1:A10).
- ROUND: This formula rounds a number to a specified number of decimal places. For example, if you want to round the value in cell A1 to two decimal places, you would use the formula =ROUND(A1,2).
- SQRT: This formula calculates the square root of a number. For example, if you want to calculate the square root of the value in cell A1, you would use the formula =SQRT(A1).
- POWER: This formula raises a number to a specified power. For example, if you want to raise the value in cell A1 to the power of 2, you would use the formula =POWER(A1,2).
Excel maths formulas are a powerful tool for data analysis and manipulation. By using these formulas, you can quickly perform complex calculations and analyze large amounts of data with ease. Whether you’re a student, a business professional, or a data analyst, Excel maths formulas are an essential tool for your work.