Function Reference

All Eaze built-in functions organized by family. Function names follow Excel convention — UPPERCASE for the spreadsheet library, mixed-case for system/styling/row helpers.

Family	Functions
Logical	TRUE, FALSE, NOT, IF, COALESCE / FIRSTNOTNULL, ISNULL, ISNULLORZERO, ISNULLOREMPTYSTR, ISNUMBER, ISNUMERIC, ISERROR, IFERROR, NZ
Math / Trig	ABS, SIGN, ROUND, CEILING, FLOOR, SUM, MOD, POW, EXP, LN, LOG, LOG10, SIN, COS, TAN, ASIN, ACOS, ATAN, ATAN2, SQRT, PI, RAND, NUM_MIN
Statistical	AVERAGE / AVERAGEA, COUNT / COUNTA / COUNTBLANK, MAX / MAXA, MIN / MINA, STDEV / STDEVA / STDEVP / STDEVPA, VAR / VARA / VARP / VARPA
Text	CONCAT, SUBSTRING, SPLIT, LEFT, RIGHT, LEN, REPLACE, LOWER, UPPER, TRIM, TOSTRING, TONUMBER, NEWLINE
Date	DATE, DATEVALUE, TODATE, NOW, FORMATDATE, TZUTC, TZLocal
Time Frame helpers	DateStart, DateEnd, YearNum, MonthNum, WeekNum, DayOfWeekName, DayOfMonthNum, …
Financial	AMORLINC, AMORLINCMTH
System	ARRAY, NEWID, Window, EVAL, JsonParse, JsonStringify, ApiBase
Misc / LHS helpers	LHS, LHSVALUE, tmpl_foreach_operand
Row Collection	ADDROWFIRST, ADDROWLAST, ADDROWAFTER, ADDROWBEFORE, IsSummaryRow, IsRowLocked, GetCallContextRow
Cell and Row Styling	SETROWSTYLE, SETCELLSTYLE