- From
- Promptivity <newsletter@promptivity.ai>
- Subject
- One AI Use Case: a spreadsheet formula you can check by hand
The problem
You know what the column should calculate, but not how to write the formula.
Recommended approach
Use the AI in your spreadsheet if you have it (Copilot in Excel or Gemini in Sheets); otherwise describe your columns to a general assistant. State the rule in plain words with one worked case and its right answer, ask for the formula plus an explanation, then test it on rows you can check by hand, including blanks.
Try it today
- Describe your columns. Column letters, what each holds, and the units.
- State the rule. In plain words, with one worked case and its right answer.
- Ask for the formula. Use the prompt below.
- Test the edge cases. Try blanks, zeros, text in number columns, and the first and last rows.
- Keep the explanation. Add a note next to the formula saying what it does.
Try this prompt
I use [Excel / Google Sheets]. Columns: [A = what it holds, B = what it holds]. Rule in plain words: [what the new column should calculate]. Worked case: [row 2 should give this answer]. Give me the formula, explain each part in plain English, and say how it handles blank or text cells. Then list 3 test cases I should check by hand.
Watch out for
- Figures for financial statements, payroll or tax that need a qualified reviewer.
- You can't state the rule in words yet; agree the business rule first.
- You rarely need to share real data: describe the columns, or use made-up rows, when you use a personal AI tool.
Learn more
Read the full guide: tool options, costs and evidence →
You get this because you confirmed your subscription to One AI Use Case a Day. Unsubscribe · Stop tracking my opens and clicks · Privacy
Promptivity LLC · 4051 Veterans Blvd, Ste 209 PMB 169, Metairie, LA 70002
Questions or support: support@promptivity.ai
Product names are trademarks of their owners; Promptivity is not affiliated with them.