Date and time
DATE
DATEDIF
DATEVALUE
DAY
DAYS
EDATE
EOMONTH
HOUR
MINUTE
MONTH
NETWORKDAYS
NOW
SOWEEK
TIME
TIMEVALUE
TODAY
WEEKDAY
WEEKNUM
WORKDAY
YEAR
YEARFRAC
Financial
IRR
NPV
PMT
Information
CELL
TYPE
Logical
AND
FALSE
IF
IFERROR
IFNA
IFS
NOT
OR
TRUE
ISBLANK
ISERROR
ISNUMBER
Lookup
ADDRESS
CHOOSE
COLUMN
COLUMNS
HLOOKUP
INDEX
JSONLOOKUP
LOOKUP
MATCH
ROW
ROWS
SORT
SORTBY
VLOOKUP
Math
ABS
EVEN
FLOOR
INT
MOD
ODD
PRODUCT
QUOTIENT
RAND
RANDBETWEEN
ROUND
ROUNDDOWN
ROUNDUP
SQRT
SUM
SUMIF
SUMIFS
SUMPRODUCT
TRUNC
Statistical
AVERAGE
AVERAGEIF
AVERAGEIFS
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
COUNTUNIQUEIFS
FORECAST
MAX
MAXIFS
MEAN
MEDIAN
MIN
MINIFS
PERCENTILE
PERCENTILE.EXC
PERCENTILE.INC
QUARTILE
QUARTILE.EXC
QUARTILE.INC
RANK
Text
CHAR
CLEAN
CONCAT
CONCATENATE
EXACT
FIND
LEFT
LEN
LOWER
REGEXMATCH
RIGHT
MID
SEARCH
SUBSTITUTE
TEXT
TEXTAFTER
TRIM
UPPER
VALUE