Free AI Excel Formula Helper Prompt

Use this when you know what the spreadsheet should do but do not know the exact formula.

Support for $20 Build a custom prompt See full prompt pack

Copy This Prompt

Write the spreadsheet formula I need. Give versions for Excel and Google Sheets if they differ. Explain it in plain English and include two example rows to test it.

What I want calculated:
[describe result]
Spreadsheet app:
[Excel/Google Sheets/unsure]
Columns or cells:
[describe columns and sample values]
Rules:
[conditions, blanks, dates, text matching, rounding, etc.]
Where the formula should go:
[cell or column]

Follow-Up Prompts

Make the formula easier to read with helper columns.

Explain why this formula returns an error.

Give me a version that handles blank cells.