Write a Spreadsheet Formula From a Description

Turn a plain-English calculation into a working Excel or Google Sheets formula, with an explanation and a test suggestion.

productivity spreadsheets

0 likes 0 dislikes

Prompt

    Write a spreadsheet formula for what I describe.

What I want to calculate:
{{goal}}

Spreadsheet (Excel or Google Sheets): {{app}}

The relevant cells/columns and what they hold (e.g. "A2:A100 = order totals, B = region"):
{{layout}}

Please:
1. Give the formula, using the cell references above.
2. Explain in plain language what it does and how it works.
3. Note any assumptions (how you handled blanks, text vs. numbers, ties) and edge cases that could trip it up.
4. Suggest a quick way to sanity-check it on a few rows before applying it to the whole sheet.

Prefer a clear, standard formula over a clever nested one; if there's a simpler alternative (a helper column, a pivot), mention it. Excel and Sheets differ on some functions — make sure the formula fits the one I named. If my layout is ambiguous, ask.

Like this prompt?

Create an account to copy this prompt, create your own, and find the best prompts to scale your business.