Excel Function List
Excel functions by category. Optional arguments in white. Click any function for a detailed description with formula examples. Also see 500 Formulas and 101 Functions.
Logical
Date and time
Lookup and reference
Look up a value in a table arranged horizontally
lookup_valuetable_arrayrow_indexrange_lookup
Lookup a value in a table by matching on the first column
lookup_valuetable_arraycolumn_index_numrange_lookup
Text
Dynamic array
Lookup values in range or array
lookuplookup_arrayreturn_arraynot_foundmatch_modesearch_mode
Engineering
Financial
Information
Math
Trigonometry
Statistical
Predict value with a seasonal trend
target_datevaluestimelineseasonalitydata_completionaggregation
Get confidence interval for forecast value at given date
target_datevaluestimelineconfidence_levelseasonalitydata_completionaggregation
Get length of the seasonal pattern
valuestimelinedata_completionaggregation
Get statistical value related to forecasting
valuestimelinestatistic_typeseasonalitydata_completionaggregation
Web
Database
Download 100+ Important Excel Functions
Get over 100 Excel Functions you should know in one handy PDF.