Learning level
62/100
Supported Formula Functions
VauSheet · 61–80 · Cloud & ProductivityProduct version
1.0.1
Guide status
Reference
Sections
2
Supported Formula Functions
Implementation-backedReference the functions implemented in the current VauSheet formula runtime instead of assuming full Microsoft Excel compatibility.
What this guide covers
Current function set
Excel compatibility note
Quick facts
Version1.0.1
CompatibilityVauSheet runtime
ReferencesA1 notation
AutocompleteSupported names
Documentation rule: this VauSheet section describes the current implemented product behavior. It avoids claiming full Microsoft Excel parity or live-cursor collaboration where the current build does not provide it.
01
Current function set
Version 1.0.1 implements a focused spreadsheet function runtime.
Aggregation · SUM, AVG, AVERAGE, MIN, MAX, COUNT, COUNTA
Criteria · SUMIF, COUNTIF, AVERAGEIF
Logical · IF, AND, OR, NOT
Math · ABS, SQRT, POWER, MOD, INT, ROUND, ROUNDUP, ROUNDDOWN, CEILING, FLOOR
Text · LEN, TRIM, LEFT, RIGHT, MID, FIND, SUBSTITUTE, TEXTJOIN, LOWER, UPPER, CONCAT
Date/time · TODAY, NOW, DATE, YEAR, MONTH, DAY
Lookup · VLOOKUP
02
Excel compatibility note
Do not assume every Excel function is available. If a function is not in the VauSheet autocomplete/runtime list, treat it as unsupported until a release explicitly adds it.
Updated 2 Sep 2026VauSheet 1.0.1