7 Essential Excel formula

Here are seven essential Excel formulas that you should know:

1. SUM: The SUM function adds up a range of numbers. For example, if you have values in cells A1 to A5, you can calculate the sum as follows: =SUM(A1:A5)
2. AVERAGE: The AVERAGE function calculates the average of a range of numbers. To find the average of values in cells B1 to B10: =AVERAGE(B1:B10)
3. COUNT: The COUNT function counts the number of cells with numeric values in a given range. For instance: =COUNT(C1:C20)
4. COUNTA: Similar to COUNT, but it counts all non-empty cells (including text and dates).
5. IF: The IF function allows you to create conditional statements. For example: =IF(D1>10, "High", "Low")
6. TRIM: The TRIM function removes extra spaces from text. Use it like this: =TRIM(E1)
7. MAX & MIN: These functions return the maximum and minimum values in a range: =MAX(F1:F10) =MIN(F1:F10)