Here’s a list of common Excel formulas with examples:
- SUM: Adds up a range of cells. Example:
=SUM(A1:A5) - AVERAGE: Calculates the average of a range of cells. Example:
=AVERAGE(B1:B5) - COUNT: Counts the number of cells in a range that contain numbers. Example:
=COUNT(A1:A5) - MAX: Returns the largest value in a range of cells. Example:
=MAX(B1:B5) - MIN: Returns the smallest value in a range of cells. Example:
=MIN(B1:B5) - IF: 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") - VLOOKUP: Searches for a value in the first column of a range and returns a value in the same row from a specified column. Example:
=VLOOKUP(A1,B1:C5,2,TRUE) - INDEX: Returns the value of a cell in a specified row and column of a range. Example:
=INDEX(B1:C5, 2, 2) - MATCH: Searches for a value in a range and returns the relative position of the value within the range. Example:
=MATCH(A1,B1:B5,0) - CONCATENATE: Joins two or more values together into a single text string. Example:
=CONCATENATE(A1," ",B1)
These are just a few of the most commonly used Excel formulas. There are many others available to perform a wide range of calculations and manipulations in your spreadsheets.
