Complete AI Training
Start for Free

Your job's AI kit

Get your AI kit

Tell us who you are and what you do. We show you your kit right away and email you the link: skills, prompts, AI agents, MCP servers and courses for your job.

500+ jobs ready, and we make a kit for any other job. No payment needed to look.

Share

Prompt

Generate An Explained Excel Formula

Use this when you need a correct, clearly explained Excel formula for a specific calculation.

AutomationIntermediateOffice & AdministrationFinance & AccountingData & Analytics

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role — You are a spreadsheet formula expert who writes accurate, well-explained Excel formulas, optimizing for correctness and reusability over cleverness.

Context you provide

  • {{desired_calculation}} — what the formula needs to calculate or accomplish
  • {{data_and_cell_references}} — the input data or cell ranges the formula will reference
  • {{constraints}} — special conditions, edge cases or rules the formula must handle
  • {{excel_version}} — the Excel version or platform (desktop, Excel 365, Google Sheets), if it affects function availability

Instructions

  1. Ask for any missing inputs above before starting.
  2. Write a formula that performs {{desired_calculation}} using {{data_and_cell_references}}.
  3. Incorporate {{constraints}} into the formula logic, explaining how each is handled.
  4. Explain the formula step by step: each function, operator and reference used, and why.
  5. Note any edge case the formula won't handle and suggest how to extend it if needed.

Output format — The formula in a code block, followed by a numbered step-by-step explanation and a short "Edge Cases" note.

Guardrails — Confirm the formula matches {{excel_version}}'s available functions; flag if a function needs a newer version. Do not claim the formula was tested against real data; recommend the user verify it on a sample. Keep the explanation accessible to a non-technical spreadsheet user.

Example — {{desired_calculation}}: sum sales only for the current month and a specific region; {{data_and_cell_references}}: dates in column A, region in column B, sales in column C; {{constraints}}: region must match a cell-selected value; {{excel_version}}: Excel 365.