# Excel Formulas List Pdf Excel Formulas List Pdf, All Excel Formulas with Examples. Advanced Excel Formulas PDF.

## Excel Formulas List Pdf

### Excel Formulas with Examples

Excel has a vast range of formulas that can perform various calculations and manipulations of data. Here is a list of some of the most commonly used Excel formulas, along with examples:

1. SUM: This formula adds up a range of cells. Example: =SUM(A1:A5)
2. AVERAGE: This formula calculates the average of a range of cells. Example: =AVERAGE(A1:A5)
3. COUNT: This formula counts the number of cells in a range that contain numbers. Example: =COUNT(A1:A5)
4. MAX: This formula returns the highest value in a range of cells. Example: =MAX(A1:A5)
5. MIN: This formula returns the lowest value in a range of cells. Example: =MIN(A1:A5)
6. IF: This formula returns one value if a condition is true and another value if it’s false. Example: =IF(A1>10, “Greater than 10”, “Less than or equal to 10”)
7. VLOOKUP: This formula searches for a value in the first column of a table and returns a value in the same row from a specified column. Example: =VLOOKUP(A1, A2:B5, 2, TRUE)
8. HLOOKUP: This formula searches for a value in the first row of a table and returns a value in the same column from a specified row. Example: =HLOOKUP(A1, A2:B5, 2, TRUE)
9. INDEX/MATCH: This formula returns the value of a cell in a specified row and column of a table. Example: =INDEX(A2:B5, MATCH(A1, A2:A5, 0), 2)
10. CONCATENATE: This formula combines text from multiple cells into one cell. Example: =CONCATENATE(A1, ” “, A2)

This is just a brief overview of some of the most common Excel formulas. There are many more formulas available in Excel that can perform various functions, including statistical analysis, text manipulation, and financial calculations.