Spreadsheet formulas explained, side by side

Spreadsheet Formulas, Explained Side by Side

65 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].

Browse by category

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

Averages, medians, spread, ranks and percentiles.

    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.