Dustread

AI prompt to get the right Excel formula

Works in ChatGPT, Gemini · Free plan is enough · Updated 18 November 2026

The prompt

You are an Excel expert who explains formulas simply.
I use [Excel 365 / Excel 2016 / Google Sheets].

My sheet: [describe the columns, e.g. "A = invoice date, B = client, C = amount, D = paid (Yes/No)"]. Data is in rows [2 to 500].
What I want: [in plain words, e.g. "total unpaid amount for each client in a summary table" / "percentage change from last month in column E"].

Give me:
1. The formula, ready to paste, and which cell to put it in.
2. A line-by-line explanation of each part.
3. A small test: three example rows and the result the formula should give, so I can check it.
4. The most common mistake people make with this formula.
If there is a simpler way (a pivot table or a built-in feature), tell me that first.

Replace the parts in [square brackets] before you send it.

How to use it

  1. Open ChatGPT or Gemini and start a new chat.
  2. Tap Copy prompt, paste it, and replace every part in [square brackets] with your details. Placeholders are fine for names and personal data.
  3. Send it, then improve the draft in the same chat: "shorter", "more formal", "in Hindi".
  4. Read the final version yourself before you use it. Check every number, date and name.
  • Describe the columns by letter. "Column C is amount" gets a correct formula far more often than "the amount column".

Do not paste Aadhaar, PAN, bank details, salaries or anyone's personal data into a public AI tool. Use placeholders and add the real details in your own document.

Example result

A ready-to-paste formula such as a SUMIFS for unpaid totals, with the exact cell to put it in, followed by a short explanation of each part (which range is summed, which condition checks the client, which checks "No"). Three example rows show the result you should see, and a closing note warns about the usual mistake, such as forgetting the $ signs before copying the formula down.

Described in words: what you get depends on your photo or details, and on the tool.

Variations

Send one of these as your next message in the same chat, or use it to replace the matching line in the prompt.

Fix my formula

Here is my formula and the error it gives: [formula] [error]. Explain what is wrong and give the corrected version.

Percentage

I need the percentage of each value in column C out of the column total, and the percentage change between column B and C. Give both formulas.

VLOOKUP to XLOOKUP

Rewrite this VLOOKUP as XLOOKUP and explain why it is safer: [formula].

Hindi

Explain the formula in simple Hindi, keeping function names in English.

More finance and accounts prompts

All finance and accounts prompts · The whole prompt library