Spreadsheet formulas explained, side by side

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.

TopicExcelGoogle SheetsAirtableNotion (Formulas 2.0)
Start of formula==No =; type into the formula fieldNo =; type into the formula property
Referring to dataCells: A2, A2:A10, Sheet2!B3Same as Excel; also whole columns A:AFields: {Unit Price} (braces optional for one-word names)Properties: prop("Unit Price") or the property chip
Works onAny range of cellsAny range of cellsOne record (row) at a time; use rollups to aggregate linked recordsOne 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 / falseTRUE, FALSETRUE, FALSETRUE(), FALSE() (or 1 / 0)true, false
Not equal<><>!=!=
And / orAND(a, b), OR(a, b)Same as ExcelAND(a, b), OR(a, b)and(a, b) / a and b, or() / a or b
DatesSerial 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")
ListsArray constants {1, 2, 3}; rangesArray 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 IFERRORSame as Excel#ERROR!, NaN, Infinity; test with ISERROR()The formula shows an error message; guard with if() and empty()
Case of namesNot case-sensitiveNot case-sensitiveNot 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.