Spreadsheet formulas explained, side by side

Spreadsheet Formulas, Explained Side by Side

82 common spreadsheet functions, each with its exact syntax in Microsoft Excel, Google Sheets, Airtable and Notion, a plain-English explanation, worked examples, and a live tester: type your own numbers, see the result, then copy the formula straight into your sheet.

Excel

Starts with =, refers to cells like A2:A10, uses TRUE/FALSE.

Google Sheets

Same grammar as Excel plus extras such as SPLIT, REGEXMATCH and QUERY.

Airtable

No = and no cell ranges: refer to fields like {Price}, one record at a time.

Notion

Formulas 2.0: lowercase functions, prop("Price"), lists like [1, 2, 3].

Need a calculator instead?

This is the spreadsheet section of FormulaShelf. The FormulaShelf calculators solve 130+ formulas directly — mortgage, compound interest, percentages, standard deviation and more — each with the formula and a worked example.

Browse by category

Sums, products, rounding, remainders, powers and roots.

SUMIF, COUNTIF and friends: totals that only include matching rows.

IF, IFS, AND, OR, SWITCH and error handling.

Building dates, adding months, counting days and workdays.

VLOOKUP, XLOOKUP, INDEX/MATCH, FILTER, SORT and UNIQUE.

Loan payments, future value, present value, NPV and IRR.

How to use this site

  1. Find the function you need by category, by the A–Z list, or with the search box.
  2. Check the syntax table for your app. Airtable and Notion do not have every Excel function; when they don't, we show the closest working formula.
  3. Test your own values in the tester. It reproduces Excel and Google Sheets rules, including rounding, error values like #N/A and date serial numbers.
  4. Press Copy next to your app and paste the formula into a cell, formula field or formula property. For range-based functions, the tester also gives you sample data to paste at cell A1.

New to moving formulas between apps? Read the syntax guide for the differences in cell references, text, dates and lists, or see the compatibility chart.