Function Reference
EngCanvas ships 196 built-in functions across 12 categories. Every function is unit-aware: arguments carry their dimensions, and results come back with the unit the math implies.
Function names are case-insensitive — SUM, Sum, and sum all resolve to the same
function.
Browse
The complete function index lists every function alphabetically and by category, with syntax, parameters, and worked examples.
Categories
| Category | What it covers |
|---|---|
| Math | Arithmetic, rounding, logs, exponents — SQRT, ROUND, MOD, LN |
| Trig | Trigonometric and hyperbolic — SIN, ATAN2, DEGREES |
| Statistical | Descriptive statistics and regression — AVERAGE, STDEV, SLOPE |
| Aggregate | Range aggregation with criteria — SUM, SUMIFS, COUNTIF |
| Logical | Branching and boolean logic — IF, IFS, SWITCH, AND |
| Lookup | Table lookup and reference — VLOOKUP, XLOOKUP, INDEX, MATCH |
| Matrix | Linear algebra — INV, DET, TRANSPOSE, EIGVAL, QR |
| Text | String manipulation — CONCAT, LEFT, SUBSTITUTE, TEXT |
| Information | Type and error tests — ISNUMBER, ISERROR, ISBLANK |
| Engineering | Interpolation, number bases, engineering helpers — LINTERP, BILINTERP, DEC2BIN, REBAR |
| DynamicArray | Array-producing functions — SORT, FILTER, UNIQUE, SEQUENCE |
| Date | Dates and calendars — TODAY, EDATE, EOMONTH, WEEKDAY |
Regenerating this reference
The per-function pages under /function-reference/ are generated from the app's
function registry. After adding or changing a function, regenerate them:
pnpm --filter @engcanvas/docs generate:functions
Next steps
- Formula Syntax — how to call functions in an expression
- Operators — arithmetic and comparison behavior with units
- Special Values — constants and error handling