Shop / Prompts

Explainable Spreadsheet Formula — Formula & Sanity-Check Prompt for Office Coordinators

A formula that looks plausible can quietly point at the wrong column.

$5.99 Buy on Payhip

Instant download after checkout. Sold and delivered by Payhip.

Who this is for

• Office coordinators maintaining Excel or Google Sheets
• Need to translate a calculation request into an understandable formula with a test case
• Designed to be usable from copied inputs, without specialist prompt-writing knowledge

Who this is not for

• Anyone expecting it to open or run their actual workbook — it works from the mapping and sample values you paste
• Anyone who needs every edge case calculated for them — it provides a manual check, and you must validate your workbook

What's inside

• Copyable prompt
• Input-field guide
• Sample calculations
• Three dry-run cases

See it work (sample 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.

Sample data above is fictional, shown so you can judge the output before buying.

How it works

1. Buy and download the file from Payhip.
2. Open it and copy the prompt into your AI tool (ChatGPT, Claude or similar).
3. Give it your facts — it asks for anything missing instead of inventing it.

Questions

Get it on Payhip — $5.99

Related tools