Return the first non-empty value
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
Use formulas in F2:F5 to return the first non-empty value from C, D, or E, otherwise B.
Starting spreadsheet
Fallbacks| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | |||
| 3 | 2 | Base B | Middle B | Later B | ||
| 4 | 3 | Base C | First C | Middle C | ||
| 5 | 4 | Base D |
A passing output
Autosheet in Excel · Opus 5.5F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Pass criteria
All must be met, checked automatically.F2:F5hold the expected values, from formulas
Passed 22
Autosheet in Excel Opus 5.5 · Medium
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Autosheet in Excel GPT-6 Astra · Low
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Autosheet in Sheets Opus 5.5 · Medium
F2=IF(C2<>"", C2, IF(D2<>"", D2, IF(E2<>"", E2, B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Autosheet in Excel Sonnet 5.5 · Medium
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Claude in Excel Opus 5.5 · High
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Autosheet in Excel Haiku 5.5 · High
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Claude in Sheets Opus 5.5 · Medium
F2=IF(LEN(TRIM(C2)),C2,IF(LEN(TRIM(D2)),D2,IF(LEN(TRIM(E2)),E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Claude Code + Sheets MCP Opus 5.5 · Medium
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Autosheet in Excel GPT-6.1 Sol · Medium
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Claude Code + Autosheet MCP Opus 5.5 · Medium
F2=IF(C2<>"", C2, IF(D2<>"", D2, IF(E2<>"", E2, B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
ChatGPT + Autosheet MCP GPT-6 · Medium
F2=IF(C2<>"", C2, IF(D2<>"", D2, IF(E2<>"", E2, B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Autosheet in Sheets Haiku 5.5 · High
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
ChatGPT in Excel GPT-6 Astra · Medium
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Claude in Excel Haiku 5.5 · High
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Claude in Sheets Haiku 5.5 · High
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Autosheet in Excel GPT-6 Luna · High
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Copilot in Excel Auto
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
ChatGPT + Drive MCP GPT-6 · Medium
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
ChatGPT in Excel GPT-6 Luna · High
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
Gemini in Sheets Auto
F2=IFS(C2<>"", C2, D2<>"", D2, E2<>"", E2, TRUE, B2)
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
ChatGPT in Sheets GPT-6 Astra · Medium
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |
ChatGPT in Sheets GPT-6 Luna · High
F2=IF(C2<>"",C2,IF(D2<>"",D2,IF(E2<>"",E2,B2)))
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | ID | Default | Choice C | Choice D | Choice E | Result |
| 2 | 1 | Base A | Preferred A | Preferred A | ||
| 3 | 2 | Base B | Middle B | Later B | Middle B | |
| 4 | 3 | Base C | First C | Middle C | First C | |
| 5 | 4 | Base D | Base D |