ƒ Functions

All functions.

45 functions documented. Click in for syntax, arguments, examples, and edge cases.

Lookup & reference

XLOOKUP INDEX MATCH OFFSET INDIRECT CHOOSECOLS CHOOSEROWS

Logical

IF IFS AND OR NOT XOR SWITCH IFERROR

Array & dynamic

LAMBDA LET MAP REDUCE SCAN BYROW BYCOL MAKEARRAY FILTER UNIQUE SORT TEXTSPLIT

Text

TEXTJOIN TEXTBEFORE TEXTAFTER REGEXEXTRACT SUBSTITUTE CONCAT TRIM

Date & time

EDATE EOMONTH NETWORKDAYS WEEKDAY DATEDIF

Financial

NPV IRR XIRR PMT FV PV