Google Sheets, without the guesswork

Every function explained with a worked example you can copy — and free tools that build the formula for you.

Browse the function reference — 15 functions

Start here

• 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.