Formula Basics

Implementation-backed

Write VauSheet formulas with =, A1 references, ranges, operators and supported functions.

What this guide covers

Formula syntax

Function calls

Recompute

Quick facts

Version1.0.1

SurfaceWeb browser

StorageCloud + local checkpoint

ThemeLight · white/orange

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

Formula syntax

A formula starts with =. Cell references use A1 notation, for example =A1+B1 or =SUM(A1:A10).

02

Function calls

Function names are parsed by the VauSheet formula runtime. Unsupported names are not silently treated as Excel-compatible functions.

03

Recompute

When workbook cells change, formula results are recomputed. Larger cell sets can use the worker-based recompute path to keep the UI responsive.

Continue learning

Open the related VauSheet guides that naturally follow this topic.

62/100

Supported Formula Functions

Reference the functions implemented in the current VauSheet formula runtime instead of assuming full Microsoft Excel compatibility.

60/100

References, Ranges & Operators

Use A1 references, rectangular ranges and VauSheet's supported arithmetic, text and comparison operators.

76/100

Formula Errors & Recalculation

Troubleshoot unsupported functions, invalid ranges, division errors and recomputation behavior.