Spreadsheet formulas explained, side by side

Spreadsheet Function Compatibility Chart

Which functions exist in Excel, Google Sheets, Airtable and Notion? Excel and Google Sheets share almost the same function library. Airtable and Notion formulas work on one record at a time, so range-based functions either need a rollup field or a different approach.

Coverage of the 82 functions on this site
AppBuilt inWorkaroundNot available
Excel8200
Google Sheets8200
Airtable451522
Notion37414

✔ built-in function   ≈ works with a workaround formula   ✘ not available

FunctionExcelGoogle SheetsAirtableNotion
Math & Rounding
SUM✔✔✔✔
PRODUCT✔✔≈≈
ROUND✔✔✔≈
ROUNDUP✔✔✔≈
ROUNDDOWN✔✔✔≈
INT✔✔✔✔
MOD✔✔✔✔
ABS✔✔✔✔
POWER✔✔✔✔
SQRT✔✔✔✔
CEILING✔✔✔≈
FLOOR✔✔✔≈
LOG✔✔✔✔
Statistics & Counting
AVERAGE✔✔✔✔
MEDIAN✔✔✘✔
MODE✔✔✘≈
MIN✔✔✔✔
MAX✔✔✔✔
COUNT✔✔✔≈
COUNTA✔✔✔≈
STDEV✔✔≈≈
LARGE✔✔✘≈
SMALL✔✔✘≈
RANK✔✔✘≈
PERCENTILE✔✔✘≈
Conditional Sums & Counts
SUMIF✔✔✘≈
SUMIFS✔✔✘≈
COUNTIF✔✔✘≈
COUNTIFS✔✔✘≈
AVERAGEIF✔✔✘≈
Logical
IF✔✔✔✔
IFS✔✔≈✔
AND✔✔✔✔
OR✔✔✔✔
NOT✔✔✔✔
IFERROR✔✔≈≈
SWITCH✔✔✔≈
Text
CONCATENATE✔✔✔✔
TEXTJOIN✔✔≈✔
LEFT✔✔✔✔
RIGHT✔✔✔≈
MID✔✔✔✔
LEN✔✔✔✔
TRIM✔✔✔≈
UPPER✔✔✔✔
LOWER✔✔✔✔
PROPER✔✔✘≈
SUBSTITUTE✔✔✔✔
FIND✔✔✔≈
SEARCH✔✔✔≈
SPLIT✔✔✘✔
REPT✔✔✔✔
VALUE✔✔✔✔
REGEXMATCH✔✔✔✔
Date & Time
DATE✔✔≈≈
TODAY✔✔✔✔
YEAR✔✔✔✔
MONTH✔✔✔✔
DAY✔✔✔✔
WEEKDAY✔✔✔✔
EDATE✔✔✔✔
EOMONTH✔✔≈≈
DATEDIF✔✔≈≈
NETWORKDAYS✔✔✔✘
WORKDAY✔✔✔✘
DAYS✔✔✔✔
Lookup & Reference
VLOOKUP✔✔✘≈
XLOOKUP✔✔✘≈
INDEX✔✔✘≈
MATCH✔✔✘≈
INDEX + MATCH✔✔✘≈
CHOOSE✔✔≈≈
FILTER✔✔✘✔
UNIQUE✔✔≈✔
SORT✔✔✘≈
Financial
PMT✔✔≈≈
FV✔✔≈≈
PV✔✔≈≈
NPER✔✔≈≈
RATE✔✔✘✘
NPV✔✔≈≈
IRR✔✔✘✘