Generate an Excel formula
A ready-to-use “Data & Analysis” AI prompt template. Replace the (bracketed) parts below with your own needs.
Prompt template
In a spreadsheet I want to achieve: (describe the need, e.g., "a monthly sum by dates in column B"). Give me a working Excel and Google Sheets formula, and explain the role of each part.
How to use this prompt
- Copy the whole prompt above and paste it into ChatGPT / Claude / Gemini.
- Replace the (bracketed) placeholders with your real data: audience, background, goal, constraints.
- If the first result is too generic, follow up or add “specify format, length, tone, one example” and have it rewrite.