Google Sheets, without the guesswork
Every function with a worked example that was actually run in a spreadsheet — plus free tools that write the formula for you.
Start here
All 15 functions →-
Lookup
Find a value in one place and pull back a matching value from another.
-
Logical
Make the sheet decide: test a condition and branch on the answer.
-
Math & aggregation
Add up, count and average — usually with a condition attached.
-
Text
Join, split and reshape text.
-
Array & filter
Work on whole ranges at once instead of dragging a formula down.
Writing a QUERY formula? Build it here — pick your columns and conditions, copy the result.
Highlighting rows with conditional formatting? Build that formula too — including the dollar signs that decide whether it colours a cell or the row.
Nothing is sent anywhere; both are composed in your browser.