Write an Excel or Google Sheets Formula from a Plain-English Description
Get a ready-to-paste Excel or Google Sheets formula built for your version and columns, with a step-by-step walkthrough and one test case to check it.
You getFormula, walkthrough and test case
Prompt
Act as a spreadsheet analyst who writes Excel and Google Sheets formulas every day.
Your job: turn my plain-English description into a working formula. Before writing anything, ask me these questions in one message and wait for my answers:
1. Excel or Google Sheets? If Excel, which version (Microsoft 365, 2021, 2019 or older)?
2. What should the formula do, in one or two sentences?
3. Which columns are involved? Give column letters, header names and 3-5 sample rows.
4. Which cell will the formula go in, and will it be copied down or across?
Rules:
- Use only functions available in my app and version. If a newer function would be simpler, mention it as an alternative.
- Use the exact cell references from my sample, with $ locks wherever the formula will be copied.
- Handle blanks and errors explicitly and state what the formula returns in each case.
- Write one formula unless a helper column is clearly simpler; if so, say why.
Output format:
1. Formula: in a code block, ready to paste.
2. Walkthrough: a numbered list explaining each function and reference in the order Excel or Sheets evaluates them.
3. Test case: one row from my sample, the expected result, and how to check it by hand.
4. Common mistakes: 2 short bullets.
End with one line naming any assumption you made about my data.Example output
Tips and common edits
Why this works
- Asking for app and version first stops the model from suggesting XLOOKUP or LET to someone on Excel 2019.
- Sample columns and the target cell mean the formula uses your real references and correct $ locks.
- A worked test case from your own data lets you verify the result in seconds instead of trusting it blindly.
Use when you know what you want a cell to calculate but not the formula. Have your app and version, column letters and a few sample rows ready. Works in ChatGPT, Claude or Gemini.
Common edits
- Ask for a version that returns 0 instead of blank so totals and charts work cleanly.
- Request an array or FILTER formula that fills the whole column at once in Microsoft 365 or Google Sheets.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Pick XLOOKUP, VLOOKUP or INDEX MATCH and Get the Exact Formula
You get one recommended lookup method for your Excel version and data layout, a paste-ready formula, and clear handling for values that have no match.
Explain Any Excel or Google Sheets Formula Step by Step in Plain English
Paste a formula and get a plain-language walkthrough in evaluation order, a table of what each part returns, common ways it breaks with fixes, and a simpler version.
Fix an Excel or Google Sheets Formula That Returns an Error or Wrong Result
Get a ranked list of the likely reasons your formula fails, a quick check for each, and a corrected formula you can paste straight into your sheet.
Build an Employee Shift Schedule and Hours Tracker with Overtime in Excel
You get a ready-to-build spreadsheet layout with formulas for overnight shifts, unpaid breaks, weekly hours per employee and highlighted overtime.
Build an Inventory Tracker Spreadsheet with Reorder Points and Low-Stock Alerts
You get exact columns, copy-ready reorder-point formulas, a status column and conditional formatting that highlights items to reorder now or this week.
Build an Invoice Template in Excel or Google Sheets with Automatic Totals
You get a cell-by-cell invoice layout with exact formulas for line totals, discount, tax, due date, and a duplicate-proof invoice numbering system.