Differences catalog

Where Excel and Google Sheets disagree

Each entry is a formula, what Excel returns, what Sheets returns, and what SheetSure writes instead. 19 of the 28 are silent: the same formula gives a different answer, and neither product shows an error.

The catalog

Search by function, formula or result. Open an entry for the full comparison; each one has its own link. The silent differences were measured in the real products, not taken from documentation. The rewrites are what SheetSure actually writes.

28 of 28 differences

How an entry gets here

A difference goes in the catalog once SheetSure handles it, or once it's measured and left as it is. Silent differences come from comparing results in real Excel and real Google Sheets on real workbooks: the cell differed, we found out why, and the rule was written from that.

Entries marked NOT FIXED YET are converted as they are. Verification still compares those cells, so they show up as “Differs” in your report instead of passing unnoticed.

How conversion and verification work: How it works. What the rules add up to on real workbooks: Evidence.

Where Excel and Google Sheets disagree

The catalog

▸Chained ^ is worked out in a different orderSILENT=2^3^2OperatorsExcel64Sheets512

▸Arithmetic on "" is an error in Excel, 0 in SheetsSILENT=0+""OperatorsExcel#VALUE!Sheets0

▸A reference to an empty cellSILENT=A1BlanksExcel0Sheets(blank)

▸An IF branch left emptySILENT=IF(A1>0,B1,)BlanksExcel0Sheets(blank)

▸TRANSPOSE over empty cellsSILENT=TRANSPOSE(A1:A4)BlanksExcel0Sheets(blank)

▸A lookup that lands on an empty cellSILENT=INDEX(A2:A9,3)LookupExcel0Sheets(blank)

▸Approximate VLOOKUP against computed keysSILENT=VLOOKUP(F1,A1:B62,2)LookupExcelthe 0.61 rowSheetsthe 0.62 row

▸TEXTSPLIT keeps number-like pieces as text=TEXTSPLIT("1,2",",")TextExcel"1"Sheets1

▸CONCAT with more than two values=CONCAT(A1,B1,C1)TextExcelall three joinedSheetstwo values only

▸TEXTBEFORE=TEXTBEFORE(A1,"-")TextExceltext before "-"Sheetsno TEXTBEFORE

▸TEXTAFTER=TEXTAFTER(A1,"-")TextExceltext after "-"Sheetsno TEXTAFTER

▸VALUE("") is an error in Excel, 0 in SheetsSILENT=VALUE("")TextExcel#VALUE!Sheets0

▸TEXTJOIN of datesSILENT=TEXTJOIN("-",,WORKDAY(A1,1),WORKDAY(A1,2))TextExcelday numbersSheetsformatted dates

▸Text functions on long decimalsSILENTNOT FIXED YET=RIGHT(68.7555555556,8)TextExcel55555556Sheets68.75556

▸XIRR with a time of day in the datesSILENT=XIRR(B2:B9,A2:A9)DatesExcel45200Sheets45200.5

▸MONTH("March"&0)=MONTH("March"&0)DatesExcel3Sheets#VALUE!

▸DAYS and DATEDIF with a negative dateSILENT=DAYS(44532,-1)DatesExcel#NUM!Sheetsa day count

▸MONTH, DAY and YEAR of the earliest dates (January–February 1900)SILENT=MONTH(0)DatesExcel1Sheets12

▸DATE before 1 March 1900SILENT=DATE(1900,1,1)DatesExcel1Sheets2

▸WORKDAY with "" daysSILENT=WORKDAY(A1,"")DatesExcel#VALUE!Sheetsa date

▸SORT with -1 for descendingSILENT=SORT(A2:B9,1,-1)ArraysExceldescendingSheetsascending

▸SORTBY=SORTBY(A2:B9,B2:B9,-1)ArraysExcelsorted by B, descendingSheetsno SORTBY

▸FILTER's third argument=FILTER(A2:A9,B2:B9>0,"none")ArraysExcel"none"Sheets#N/A

▸SEQUENCE with an omitted argument=SEQUENCE(5,,1)ArraysExcel1 to 5Sheets#NUM!

▸COUNTIF with "<>0"SILENT=COUNTIF(A2:A9,"<>0")Counting & sumsExcelcounts empty cellsSheetsskips empty cells

▸An array constant as criteriaSILENT=SUM(COUNTIF(A2:A9,{">0","<0"}))Counting & sumsExcelboth criteriaSheetsfirst criterion only

▸SUMIFS with an array of criteriaSILENT=SUM(SUMIFS(C2:C9,A2:A9,{"a","b"}))Counting & sumsExcelone total per criterionSheetsfirst criterion only

▸AGGREGATE=AGGREGATE(15,6,A2:A9,1)Counting & sumsExcelsmallest, errors skippedSheetsno AGGREGATE

How an entry gets here