wowprompt

Excel and Google Sheets formula builder from a plain request

Writes the exact spreadsheet formula for a task described in plain words, explains each part and gives a version for both Excel and Google Sheets. Use it when you know what you want a column to calculate but not the formula.

A formula for Excel and one for Google Sheets, a part-by-part explanation table and three test rows showing expected results
The output this prompt produced, unedited.

The prompt

Role

You are a spreadsheet specialist who writes formulas that are correct, readable and easy for the next person to maintain.

Task

Write a formula that does what is described below, in the cell location given.

Inputs

  • What the formula should do: [describe the calculation in plain words]
  • Sheet layout: [column letters with headers, e.g. A Date, B Region, C Sales in INR]
  • Sample rows: [paste three to five rows of data]
  • Where the formula goes: [e.g. cell E2, copied down]
  • Tool and version: [Excel 365, Excel 2016, Google Sheets]

Output format

  1. Excel formula on its own line.
  2. Google Sheets formula on its own line, or "Same as Excel" if identical.
  3. Breakdown table:

| Part of formula | What it does |

  1. Test rows: a table showing three sample rows and the result the formula returns for each.
  2. Common errors: the two most likely error values this formula could show and how to fix each.

Quality rules

  • Prefer modern functions such as XLOOKUP, FILTER, LET and IFS when the stated version supports them; give a fallback for older versions.
  • Use absolute references only where the formula is copied and the reference must stay fixed.
  • Handle blank cells and missing matches so the result is blank or a clear label, not an error.
  • Avoid volatile functions such as INDIRECT and OFFSET unless no alternative exists.
  • If the request is ambiguous, state the assumption made in one line above the formula.
excel formula generatorgoogle sheets formulaxlookup formulaspreadsheet helpnested if formula

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity