Math & Trigonometry
SUM, PRODUCT, QUOTIENT, ABS, ACOS, ASIN, ATAN, COS, SIN, TAN, CEILING, FLOOR, EXP, LN, LOG10, MOD, PI, POWER, ROUND, SQRT, TRUNC, SIGN, RAND, RANDBETWEEN
Statistical
AVERAGE, AVG, MIN, MAX, COUNT, COUNTA, MEDIAN, SUMSQ
Logical
IF, AND, OR, NOT, XOR, TRUE, FALSE
Text Processing
CONCATENATE, CONCAT, EXACT, LOWER, UPPER, TRIM, LEN, REPT
Information
ISNUMBER, ISTEXT, ISBLANK
Engineering
DEC2BIN, DEC2HEX, DEC2OCT, BIN2DEC, HEX2DEC, OCT2DEC
Live Finance API
FAPI(ticker) - Example: =FAPI("AAPL"). Pulls real data! Wait 1 second for the data to populate via live web proxy.
Examples:
=SUM(A1:A5)=IF(B2>10, "High", "Low")=FAPI("TSLA")