What formulas does Sheets support?
What formulas does Sheets support?
Yes — Google Sheets supports all standard spreadsheet formulas, including:
-
Math formulas (like
SUM,AVERAGE,ROUND) -
Logic formulas (
IF,AND,OR) -
Text formulas (
CONCAT,UPPER,LOWER) -
Date/time formulas (
TODAY,NOW,DATEDIF) -
Lookup formulas (
VLOOKUP,INDEX,MATCH) -
Array formulas and custom functions
-
Google-specific ones (
GOOGLEFINANCE,IMPORTRANGE,IMPORTDATA)
In short: if it’s a common spreadsheet function, Google Sheets supports it — and more.
