Excel function reference
Every function, explained with examples you can edit live.
19 of Excel’s 519 functions so far — syntax, realistic worked examples, and the Google Sheets equivalent for each. New functions land every week.
Looking for Google Sheets?Excel lookup functions
Lookup — 4 functions and counting.
- FILTERFilters a range of data based on criteria you defineLookupGoogle Sheets
- SORTSorts the contents of a range or arrayLookupGoogle Sheets
- XLOOKUPSearches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.LookupGoogle Sheets
- XMATCHReturns the relative position of an item in an array or range of cells.LookupGoogle Sheets
Excel financial functions
Financial — 3 functions and counting.
Excel logical functions
Logical — 3 functions and counting.
Excel statistical functions
Statistical — 3 functions and counting.
Excel compatibility functions
Compatibility — 2 functions and counting.
Excel math functions
Math — 2 functions and counting.
Excel info functions
Info — 1 function and counting.
Excel text functions
Text — 1 function and counting.