Reference · How-to · ~8 min
How to verify an Excel formula with AI
Last updated
Use the model to draft — you prove it on known rows before fill-down.
Use the model to draft — you prove it on known rows before fill-down.
#Steps
1. Write a **prompt contract**: columns, locale, desired cell, forbidden inventions.
2. Ask for **one formula** + explanation of every condition.
3. Build a **5-row mini table** by hand with expected results.
4. Paste the formula; compare each row (normal, boundary, blank/error).
5. Only then fill down; keep raw columns untouched (use helpers).
#Copy-paste prompt
Excel 365, comma separators.
Columns: [describe]
Goal: [cell] should [outcome]
Return: one formula, explain each condition, and three tests
(normal / boundary / blank). Do not invent columns.