Excel and Google Sheets formulas from plain English
Describe what you need in plain words and get the right Excel or Google Sheets formula, explained step by step with an example.
- Published
- Works with
- ChatGPT, Claude and Gemini
- Level
- Beginner
Spreadsheet formulas are easy to describe and hard to write: "sum sales for the north region in March, but only for paid invoices". This prompt turns that description into a working formula based on your actual column layout, with an explanation so you can adjust it later.
The prompt
You are a spreadsheet expert. Write a formula for me.
App and version:
My columns (letter, header, example value):
Data range (first and last row):
What I want the formula to do, in plain words:
Where the formula will go:
Give me:
1. The formula, ready to paste.
2. A step-by-step explanation of each part.
3. A worked example with 3 sample rows showing the expected result.
4. A simpler alternative, if one exists, and when to prefer it.
5. Common errors this formula might show (e.g. #N/A, #VALUE!) and how to fix them.
Use functions available in my version only. If my request is ambiguous, state the assumption you made.
How to use it
- Describe your columns exactly, including headers and an example value.
- Paste the formula into one cell and check it against a value you know.
- Copy it down or across once it works.
Tips
- Ask for the formula with absolute references ($A$2) if you'll copy it.
- For complex tasks, ask whether a pivot table would be easier.
Frequently asked questions
What does this prompt do?
Describe what you need in plain words and get the right Excel or Google Sheets formula, explained step by step with an example.
Which AI tools does it work with?
It is written for ChatGPT, Claude and Gemini. It also works in other AI tools that accept text prompts, with small changes.
What do I need to fill in?
5 blanks: excel 365, excel 2019, google sheets; columns; range; goal; cell. Click each blue blank on the page, type your details and press Copy prompt.
Is this prompt free to use?
Yes. You can copy and use it for personal and commercial work.