Fix broken formulas and validate amounts
Data operationsHardDeterministic scoringLatest run
Passed by 5 of 12 products on their best model: Autosheet in Excel, Claude in Excel, Claude Code + Sheets MCP, Claude in Sheets and Claude Code + Autosheet MCP.
Prompt
Several formulas are broken — can you find and fix them?
Also add data validation to the Amount column so only positive numbers are allowed
Starting spreadsheet
Sheet1| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | #REF! | #REF! | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | #VALUE! | #VALUE! | Disputed |
| 8 | INV-007 | Global Traders | 11000 | #VALUE! | #VALUE! | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | #REF! | #REF! | #REF! | Paid |
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | #VALUE! | #VALUE! | Disputed |
| 15 | INV-014 | NovaTech | 18600 | #VALUE! | #VALUE! | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
A passing output
Autosheet in Excel · Opus 5.5D4=ROUND(C4*0.13,2)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | 0 | 0 | Paid | |
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Pass criteria
All must be met, checked automatically.D4:E4,D8:E8andD15:E15hold the expected values, in an accepted form- Rows 7 and 14: a negative amount kept, or corrected to positive, with its tax and total, in an accepted way
C2:E16show no errorsC2:C16only accept numbers greater than a set value
Passed 7
Autosheet in Excel Opus 5.5 · Medium
D4=ROUND(C4*0.13,2)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | 0 | 0 | Paid | |
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Autosheet in Excel Sonnet 5.5 · Medium
D4=IF(ISNUMBER(C4),ROUND(C4*0.13,2),"")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | Paid | |||
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Claude in Excel Opus 5.5 · High
D2=C2*G2
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status | Tax Rate |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid | 13.0% |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending | 13.0% |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid | 13.0% |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved | 13.0% |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending | 11.0% |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed | 13.0% |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid | 13.0% |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved | 13.0% |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending | 13.0% |
| 11 | INV-010 | JetPro Services | 0 | 0 | Paid | 13.0% | |
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved | 13.0% |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid | 13.0% |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed | 13.0% |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending | 13.0% |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved | 13.0% |
Claude in Sheets Opus 5.5 · Medium
D2=IF(ISNUMBER(C2),C2*$I$1,"")
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status | Tax Rate | 13.0% | |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid | |||
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending | |||
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid | |||
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved | |||
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending | |||
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed | |||
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid | |||
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved | |||
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending | |||
| 11 | INV-010 | JetPro Services | Paid | ||||||
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved | |||
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid | |||
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed | |||
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending | |||
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Claude Code + Sheets MCP Opus 5.5 · Medium
E2=IF(C2="","",C2+D2)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | Paid | |||
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Claude Code + Autosheet MCP Opus 5.5 · Medium
D2=IF(C2="","",C2*0.13)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 988 | 8588 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | Paid | |||
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
ChatGPT in Excel GPT-6 Luna · High
D4=C4*13%
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | Paid | |||
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Failed 15
Autosheet in Excel GPT-6 Astra · Low
D4=C4*13%
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | #REF! | #REF! | #REF! | Paid |
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Why it failed: 3 cells show an error.
Autosheet in Sheets Opus 5.5 · Medium
D2=C2*0.13
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 988 | 8588 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | #REF! | #VALUE! | #VALUE! | Paid |
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Why it failed: 1 cell shows an error.
Autosheet in Excel Haiku 5.5 · High
D4=C4*0.13
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | #REF! | #REF! | #REF! | Paid |
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Why it failed: 3 cells show an error.
Autosheet in Excel GPT-6.1 Sol · Medium
D4=C4*13%
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | #REF! | #REF! | #REF! | Paid |
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Why it failed: 3 cells show an error.
ChatGPT + Autosheet MCP GPT-6 · Medium
D4=C4*0.13
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | #VALUE! | #VALUE! | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | #REF! | #REF! | #REF! | Paid |
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | #VALUE! | #VALUE! | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Why it failed: 7 cells show an error. Not met: row 7: a negative amount kept, or corrected to positive, with its tax and total.
Autosheet in Sheets Haiku 5.5 · High
D2=IF(ISNUMBER(C2),C2*$I$1,"")
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status | Tax rate | 13% | |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid | |||
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending | |||
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid | |||
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved | |||
| 6 | INV-005 | Evergreen Supply | 7600 | 988 | 8588 | Pending | |||
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed | |||
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid | |||
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved | |||
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending | |||
| 11 | INV-010 | JetPro Services | #REF! | Paid | |||||
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved | |||
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid | |||
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed | |||
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending | |||
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Why it failed: 1 cell shows an error.
ChatGPT in Excel GPT-6 Astra · Medium
E4=IF(COUNT(C4:D4)=2,C4+D4,"Inputs needed")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | Tax needed | Inputs needed | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | Tax needed | Inputs needed | Disputed |
| 8 | INV-007 | Global Traders | 11000 | Tax needed | Inputs needed | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | Amount needed | Tax needed | Inputs needed | Paid |
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | Tax needed | Inputs needed | Disputed |
| 15 | INV-014 | NovaTech | 18600 | Tax needed | Inputs needed | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Why it failed: The broken tax cells read “Tax needed” instead of the 13% tax every other row but one uses, so their totals read “Inputs needed”.
Claude in Excel Haiku 5.5 · High
D2=C2*$I$1
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status | Tax rate | 13% | |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid | |||
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending | |||
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid | |||
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved | |||
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending | |||
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed | |||
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid | |||
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved | |||
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending | |||
| 11 | INV-010 | JetPro Services | #REF! | #VALUE! | #VALUE! | Paid | |||
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved | |||
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid | |||
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed | |||
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending | |||
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Why it failed: 1 cell shows an error.
Claude in Sheets Haiku 5.5 · High
D2=C2*$I$1
| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status | Tax rate | 13.0% | |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid | |||
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending | |||
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid | |||
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved | |||
| 6 | INV-005 | Evergreen Supply | 7600 | 988 | 8588 | Pending | |||
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed | |||
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid | |||
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved | |||
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending | |||
| 11 | INV-010 | JetPro Services | #REF! | #VALUE! | #VALUE! | Paid | |||
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved | |||
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid | |||
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed | |||
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending | |||
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Why it failed: 1 cell shows an error.
Autosheet in Excel GPT-6 Luna · High
D4=C4*13%
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | #REF! | #VALUE! | #VALUE! | Paid |
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Why it failed: 1 cell shows an error.
Copilot in Excel Auto
D4=C4*13%
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | #REF! | #REF! | #REF! | Paid |
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Why it failed: 3 cells show an error.
ChatGPT + Drive MCP GPT-6 · Medium
D4=IF(ISNUMBER(C4),C4*13%,"")
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | #REF! | Paid | ||
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Why it failed: 1 cell shows an error.
Gemini in Sheets Auto
D4=C4*0.13
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | #REF! | #VALUE! | #VALUE! | Paid |
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Why it failed: 1 cell shows an error.
ChatGPT in Sheets GPT-6 Astra · Medium
E4=C4+D4
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | #REF! | #VALUE! | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | #VALUE! | #VALUE! | Disputed |
| 8 | INV-007 | Global Traders | 11000 | #VALUE! | #VALUE! | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | #REF! | #REF! | #VALUE! | Paid |
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | #VALUE! | #VALUE! | Disputed |
| 15 | INV-014 | NovaTech | 18600 | #VALUE! | #VALUE! | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Why it failed: 7 cells show an error. 6 cells in column D (tax) hold none of the accepted values, such as D4: "#REF!", and 2 other problems.
ChatGPT in Sheets GPT-6 Luna · High
D4=C4*13%
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Invoice | Vendor | Amount | Tax | Total | Status |
| 2 | INV-001 | Acme Corp | 12500 | 1625 | 14125 | Paid |
| 3 | INV-002 | Brite Solutions | 8400 | 1092 | 9492 | Pending |
| 4 | INV-003 | Clearview Tech | 9800 | 1274 | 11074 | Paid |
| 5 | INV-004 | Datasync Ltd | 15200 | 1976 | 17176 | Approved |
| 6 | INV-005 | Evergreen Supply | 7600 | 836 | 8436 | Pending |
| 7 | INV-006 | FastTrack Inc | -3200 | -416 | -3616 | Disputed |
| 8 | INV-007 | Global Traders | 11000 | 1430 | 12430 | Paid |
| 9 | INV-008 | Horizon Partners | 6750 | 877.5 | 7627.5 | Approved |
| 10 | INV-009 | InfoSystems | 13400 | 1742 | 15142 | Pending |
| 11 | INV-010 | JetPro Services | Paid | |||
| 12 | INV-011 | Keystone Group | 9200 | 1196 | 10396 | Approved |
| 13 | INV-012 | Luminary Co | 7100 | 923 | 8023 | Paid |
| 14 | INV-013 | Mercer Dynamics | -450 | -58.5 | -508.5 | Disputed |
| 15 | INV-014 | NovaTech | 18600 | 2418 | 21018 | Pending |
| 16 | INV-015 | Omega Supplies | 5900 | 767 | 6667 | Approved |
Why it failed: C2:C16 has no validation that only accepts numbers greater than a set value.