Excel Formulas

Find the formula you need in our list of ready-to-use examples. Click a formula link for a full description. Related functions appear to the right and are also links.

Average

FormulaRelated Functions
Average numbers
Average numbers ignore zero
Average top 3 scores
Weighted average

Min and Max

FormulaRelated Functions
Maximum if multiple criteria
Maximum value
Maximum value if
Minimum if multiple criteria
Minimum value
Minimum value if
nth largest value
nth largest value with criteria
nth smallest value
nth smallest value with criteria

If

FormulaRelated Functions
If cell equals
If cell is blank
If cell is greater than
If cell is not blank
If cell is this OR that
If cell is x or y and z
If else
If NOT this or that
If this AND that
Nested IF function example

Date Series

FormulaRelated Functions
Series of dates by day
Series of dates by month
Series of dates by weekends
Series of dates by workdays
Series of dates by year

Finalcial

FormulaRelated Functions
Calculate compound interest
Calculate simple interest

Internet

FormulaRelated Functions