All AutosheetBench tasks

Return the first non-empty value

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Use formulas in F2:F5 to return the first non-empty value from C, D, or E, otherwise B.

Starting spreadsheet

Fallbacks
ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred A
32Base BMiddle BLater B
43Base CFirst CMiddle C
54Base D

A passing output

Autosheet in Excel · Opus 5.5
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

How each AI configuration did

22 of 22 passRun files
Excel and Sheets · All types · All models · All outputs

Pass criteria

All must be met, checked automatically.
  • F2:F5 hold the expected values, from formulas

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed7s · 3¢
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

Autosheet in Excel GPT-6 Astra · Low

Passed6s · 5¢
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

Autosheet in Sheets Opus 5.5 · Medium

Passed10s · 2¢
Fallbacks4 cells changed

F2=IF(C2<>"", C2, IF(D2<>"", D2, IF(E2<>"", E2, B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

Autosheet in Excel Sonnet 5.5 · Medium

Passed4s · 1¢
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

Claude in Excel Opus 5.5 · High

Passed12s · 8¢
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

Autosheet in Excel Haiku 5.5 · High

Passed8s · 0.1¢
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

Claude in Sheets Opus 5.5 · Medium

Passed30s · 5¢
Fallbacks4 cells changed

F2=IF(LEN(TRIM(C2)),C2,IF(LEN(TRIM(D2)),D2,IF(LEN(TRIM(E2)),E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed26s · N/A
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

Autosheet in Excel GPT-6.1 Sol · Medium

Passed11s · 2¢
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed30s · N/A
Fallbacks4 cells changed

F2=IF(C2<>"", C2, IF(D2<>"", D2, IF(E2<>"", E2, B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed42s · N/A
Fallbacks4 cells changed

F2=IF(C2<>"", C2, IF(D2<>"", D2, IF(E2<>"", E2, B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

Autosheet in Sheets Haiku 5.5 · High

Passed12s · 0.1¢
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

ChatGPT in Excel GPT-6 Astra · Medium

Passed13s · 39¢
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

Claude in Excel Haiku 5.5 · High

Passed8s · 0.3¢
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

Claude in Sheets Haiku 5.5 · High

Passed14s · 0.3¢
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

Autosheet in Excel GPT-6 Luna · High

Passed8s · 0.1¢
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

Copilot in Excel Auto

Passed19s · N/A
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

ChatGPT + Drive MCP GPT-6 · Medium

Passed25s · N/A
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

ChatGPT in Excel GPT-6 Luna · High

Passed17s · 0.4¢
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

Gemini in Sheets Auto

Passed42s · N/A
Fallbacks4 cells changed

F2=IFS(C2<>"", C2, D2<>"", D2, E2<>"", E2, TRUE, B2)

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

ChatGPT in Sheets GPT-6 Astra · Medium

Passed21s · 31¢
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D

ChatGPT in Sheets GPT-6 Luna · High

Passed13s · 0.3¢
Fallbacks4 cells changed

F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))

ABCDEF
1IDDefaultChoice CChoice DChoice EResult
21Base APreferred APreferred A
32Base BMiddle BLater BMiddle B
43Base CFirst CMiddle CFirst C
54Base DBase D