Formula reference

Every formula function supported in Sheets, by group.

Every function Sheets supports, grouped by what it does. Write them in a cell exactly as you would in a spreadsheet — =SUM(A1:A3).

Array manipulation

Date and time

Engineering

Information

Financial

Logical

Lookup and reference

Math and trigonometry

Matrix functions

Operator

Statistical

Text

Local runtime only