References, Ranges & Operators

Implementation-backed

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

What this guide covers

Cell references and ranges

Supported operators

Division by zero

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

Cell references and ranges

Use references such as A1 and ranges such as A1:B10. Range-aware functions retrieve values from the rectangular range represented by the start and end references.

02

Supported operators

The current evaluator supports +, -, *, /, ^, &, =, !=, >, <, >= and <=.

03

Division by zero

Division by zero is rejected by the runtime and should be handled in your formula design rather than expected to return a valid numeric result.

Continue learning

Open the related VauSheet guides that naturally follow this topic.

58/100

Formula Basics

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

62/100

Supported Formula Functions

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

66/100

SUMIF, COUNTIF & AVERAGEIF

Calculate condition-based totals, counts and averages over VauSheet ranges.