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.
Starts with =, refers to cells like A2:A10, uses TRUE/FALSE.
Same grammar as Excel plus extras such as SPLIT, REGEXMATCH and QUERY.
No = and no cell ranges: refer to fields like {Price}, one record at a time.
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.
Averages, medians, spread, ranks and percentiles.
SUMIF, COUNTIF and friends: totals that only include matching rows.
Joining, splitting, trimming, searching and changing case.
Building dates, adding months, counting days and workdays.
VLOOKUP, XLOOKUP, INDEX/MATCH, FILTER, SORT and UNIQUE.
How to use this site
- Find the function you need by category, by the A–Z list, or with the search box.
- 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.
- Test your own values in the tester. It reproduces Excel and Google Sheets rules, including rounding, error values like
#N/Aand date serial numbers. - 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.