Basic Excel Formulas

Here are some useful formulas in Excel:

 

1. SUM: Adds up a range of numbers. For example, =SUM(A1:A10) will add up the values in cells A1 to A10.

 

2. AVERAGE: Calculates the average of a range of numbers. For example, =AVERAGE(A1:A10) will calculate the average of the values in cells A1 to A10.

 

3. MAX/MIN: Returns the maximum or minimum value in a range of numbers. For example, =MAX(A1:A10) will return the highest value in cells A1 to A10.

 

4. COUNT/COUNTA: Counts the number of cells in a range that contain numbers or text. For example, =COUNT(A1:A10) will count the number of cells in cells A1 to A10 that contain numbers.

 

5. IF: Evaluates a condition and returns one value if the condition is true and another value if the condition is false. For example, =IF(A1>10,"Greater than 10","Less than or equal to 10") will return "Greater than 10" if the value in cell A1 is greater than 10, and "Less than or equal to 10" if it is not.

 

6. VLOOKUP: Searches for a value in the first column of a range and returns the corresponding value in a specified column. For example, =VLOOKUP(A1,A1:B10,2,FALSE) will search for the value in cell A1 in the first column of the range A1:B10, and return the corresponding value in the second column.

 

7. CONCATENATE: Joins two or more strings of text together. For example, =CONCATENATE(A1," ",B1) will join the values in cells A1 and B1 together with a space in between.

 

These are just a few examples of the many formulas available in Excel. Learning how to use formulas can greatly improve your ability to work with data in Excel.