Excel vs Google Sheets vs Airtable vs Notion: Formula Syntax Guide
The four apps share a lot of vocabulary (IF, ROUND, LEFT) but they read formulas differently. Moving a formula from one to another usually fails on the small things below, not on the function names.
| Topic | Excel | Google Sheets | Airtable | Notion (Formulas 2.0) |
|---|---|---|---|---|
| Start of formula | = | = | No =; type into the formula field | No =; type into the formula property |
| Referring to data | Cells: A2, A2:A10, Sheet2!B3 | Same as Excel; also whole columns A:A | Fields: {Unit Price} (braces optional for one-word names) | Properties: prop("Unit Price") or the property chip |
| Works on | Any range of cells | Any range of cells | One record (row) at a time; use rollups to aggregate linked records | One page (row) at a time; relations return lists you can .map() and .filter() |
| Text | "Hello"; a quote inside is doubled: "Say ""hi""" | Same as Excel | "Hello" or 'Hello'; escape with \" | "Hello"; escape with \" |
| Join text | &, CONCAT, TEXTJOIN | &, CONCATENATE, TEXTJOIN, JOIN | &, CONCATENATE, ARRAYJOIN (rollups) | +, concat(), join() |
| True / false | TRUE, FALSE | TRUE, FALSE | TRUE(), FALSE() (or 1 / 0) | true, false |
| Not equal | <> | <> | != | != |
| And / or | AND(a, b), OR(a, b) | Same as Excel | AND(a, b), OR(a, b) | and(a, b) / a and b, or() / a or b |
| Dates | Serial numbers (1 = 1 Jan 1900); build with DATE(2026, 3, 15) | Serial numbers (same as Excel for modern dates) | Date objects; build with DATETIME_PARSE("2026-03-15") | Date objects; build with parseDate("2026-03-15") |
| Lists | Array constants {1, 2, 3}; ranges | Array literals {1, 2, 3} (rows {1; 2; 3}) | Separate arguments: SUM(1, 2, 3) | List literals [1, 2, 3] |
| Errors | #N/A, #DIV/0!, #VALUE!…; catch with IFERROR | Same as Excel | #ERROR!, NaN, Infinity; test with ISERROR() | The formula shows an error message; guard with if() and empty() |
| Case of names | Not case-sensitive | Not case-sensitive | Not case-sensitive (written in capitals by convention) | Functions are lowercase, e.g. round() |
Argument separators and regional settings
All formulas on SheetFormulas use a comma between arguments, which is the default in the United States, the UK and many other regions. If your Excel or Google Sheets locale uses a comma as the decimal mark (much of Europe and South America), the argument separator becomes a semicolon: =ROUND(2,345; 2). Excel converts formulas automatically when a workbook is opened in another locale, but pasted text is not converted, so swap the separators by hand. Airtable and Notion always use commas.
From cells to fields
A spreadsheet formula can look anywhere on the grid. Airtable and Notion formulas cannot: they see only the fields of the current record. A formula like =SUMIF(A:A, "Paid", B:B) therefore has no direct translation. Instead you link records and use a rollup (Airtable rollup field with a condition, or a Notion rollup / prop("Invoices").filter(current.prop("Status") == "Paid").map(current.prop("Amount")).sum()). Where this matters, each function page says so in its syntax table.
Dates are numbers in spreadsheets
Excel and Google Sheets store a date as the number of days since 30 December 1899, so 15 March 2026 is 46096. That is why subtracting two dates gives a number of days and why a date can suddenly display as 46096 when a cell is formatted as a number. Airtable and Notion have a real date type: use DATETIME_DIFF / dateBetween to get differences, and DATEADD / dateAdd to move dates.
Dynamic arrays
Excel 365 and Excel 2021 can return several results from one formula (FILTER, SORT, UNIQUE, SEQUENCE); the answer “spills” into neighbouring cells. Google Sheets has always done this. Older Excel versions (2019 and earlier) cannot, and show #NAME? for these functions.
Using the copy buttons
Every tester builds the same calculation in each app's own grammar. Copy the version for your app and paste it:
- Excel / Google Sheets: click a cell and paste (Ctrl+V / Cmd+V). When the formula uses ranges such as
A2:A6, first press Copy sample data and paste it at cell A1. - Airtable: open the field settings, choose Formula, and paste into the formula box. Replace the typed values with your own
{Field}names. - Notion: add a Formula property, open the editor and paste. Replace the typed values with
prop("Name")references.