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
  • SUMIF
  • COUNTIF
  • AVERAGEIF
  • IF
  • AND
  • OR
  • NOT
  • ABS
  • SQRT
  • POWER
  • MOD
  • INT
  • ROUND
  • ROUNDUP
  • ROUNDDOWN
  • CEILING
  • FLOOR
  • LEN
  • TRIM
  • LEFT
  • RIGHT
  • MID
  • FIND
  • SUBSTITUTE
  • TEXTJOIN
  • LOWER
  • UPPER
  • CONCAT
  • TODAY
  • NOW
  • DATE
  • YEAR
  • MONTH
  • DAY
  • VLOOKUP

Recompute Model

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