Formulas Guide

Formula Syntax

Formula always starts with =. Cell references use A1 notation, example: =A1+B1.

Supported Suggestions

Autocomplete is available while typing after =:

SUM
AVG
AVERAGE
MIN
MAX
COUNT
COUNTA
IF
AND
OR
NOT
ABS
ROUND
ROUNDUP
ROUNDDOWN
LEN
LOWER
UPPER
CONCAT
VLOOKUP

Recompute Model

On cell mutation, sheet formulas are recomputed. Worker-based recompute path is used for larger cell sets to keep UI responsive.