Prompt Details
Model
(claude-5-5-sonnet)
Token size
404
Example input
[PLATFORM]: Excel 365.
[SHEET MAP]: A=Item, B=Quantity, C=Unit Price; row 2: B2=3, C2=12.50; row 3: B3=2, C3=8.00.
[GOAL]: D2 should calculate per-row total, copied down.
[ERROR BEHAVIOR]: Blank quantity or price should show blank.
Example output
Input:
PLATFORM: Excel 365.
SHEET MAP: A=Item, B=Quantity, C=Unit Price; row 2: B2=3, C2=12.50; row 3: B3=2, C3=8.00.
GOAL: D2 should calculate per-row total, copied down.
ERROR BEHAVIOR: Blank quantity or price should show blank.
Output:
Goal: Multiply quantity in column B by unit price in column C, but keep incomplete rows blank.
Formula: =IF(OR(B2="",C2=""),"",B2*C2)
Paste in: D2; fill downward so row references update.
Why it works: OR detects missing inputs; otherwise the row's two cells multiply. No absolute references needed.
Manual check: Row 2 = 3 × 12.50 = 37.50; row 3 = 2 × 8.00 = 16.00.
Assumptions / verify: B and C contain numeric values, not prices stored as text.
Get this prompt + 9 more with Select$14 your first month, then $19/mo$14 first month, then $19/mo
View Select
Instant access
Commercial use
Money‑backBy purchasing this prompt, you agree to our terms of service
6
Views
CLAUDE-5-5-SONNET
A formula that looks plausible can quietly point at the wrong column. This prompt writes one Excel or Google Sheets formula from your sheet map, explains it in plain English, and adds a manual sanity check using only your sample values. If references are missing, it asks focused questions instead of guessing - no invented columns, values, or results. For office coordinators maintaining spreadsheets.
...more
Added 1 day ago
