Formulas Guide

Build spreadsheet logic with A1 references, ranges, autocomplete suggestions, and responsive recompute behavior inside the workbook.

Reference cells

=A1+B1

Summarize ranges

=SUM(A1:A12)

Conditional totals

=SUMIF(B2:B20, "Paid", C2:C20)

Lookup values

=VLOOKUP("SKU-42", A2:D80, 4)

Supported Suggestions

Autocomplete appears while typing after the equals sign.

SUMAVGAVERAGEMINMAXCOUNTCOUNTAABSSQRTPOWERMODINTROUNDROUNDUPROUNDDOWNCEILINGFLOOR

SUMIFCOUNTIFAVERAGEIFIFANDORNOT

LENTRIMLEFTRIGHTMIDFINDSUBSTITUTETEXTJOINLOWERUPPERCONCAT

TODAYNOWDATEYEARMONTHDAYVLOOKUP