Excel Formulas List: Excel formulas are essential tools for calculating values in a spreadsheet. They allow users to add, subtract, multiply, and perform various calculations on a group of numbers. In Microsoft Excel, the 'mean' or average can be calculated using predefined functions, such as AVERAGE, which computes the average of the provided numbers.
In Excel, there are two primary methods for performing calculations: formulas and functions.
Formulas: A formula is an expression that computes a value based on cell references. For example, =A1+A2+A3 adds the values in cells A1 through A3.
Functions: Functions are predefined calculations in Excel, designed to simplify complex calculations. For instance, you can use =SUM(A1:A3) to quickly add the values between those cells.
MS Excel Formulas List
| SUM Excel Formula: | SUM(number1, [number2]) |
| AVERAGE Excel Formula: | AVERAGE(number1, [number2], …) |
| MAX & MIN Excel Formula: | =MAX(A2:A5) =MIN(A2:A5) |
| COUNT & COUNTA Excel Formula: | COUNT(value1, [value2], …) |
| IF Excel Formula: | IF(logical_test, [value_if_true], [value_if_false]) |
| TRIM Excel Formula: | =TRIM(A1) |
| LEN Excel Formula: | =LEN(text) |
| CONCATENATE Excel Formula: | CONCATENATE(text1, [text2], …) |
Common Excel Formulas
- SUM
- COUNT
- COUNTA
- COUNTBLANK
- AVERAGE
- MIN
- MAX
- LEN
- TRIM
- IF
To learn more about Microsoft software updates, visit the official Microsoft website: https://www.microsoft.com/en-in
Download Excel Formulas List PDF
You can download the Excel formulas list with examples from the link below:
Download Excel Formulas List PDF
For more updates on courses, check out eSkillindia's offerings for 2025.
