Exceljet

Quick, clean, and to the point

500 Excel Formula Examples

Find the formula you need in these ready-to-use examples. Click a formula link for a full description. Related functions appear to the right and are also links. Also see our function guide: Excel functions for the minimalist.

Count

Sum

Average

Min and Max

Lookup

If

Conditional formatting

Data validation

Rank

Round

Date and Time

Date series

Text

Financial

Workbook

Internet

Names

Percentage

Range

Miscellaneous

Thank you for all the tips/tricks I received, they are very helpful. -Xin
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course