Copilot prompt for an Excel formula
A copy-paste prompt that turns a plain-language description into a working Excel or Google Sheets formula, with a one-line explanation.
Tuned for Copilot · structured role / context / task / output
Open in the builder →Ready-to-use prompt
# Role Approach this as a rigorous, evidence-driven problem. Reason from the facts, make your assumptions explicit, and commit to a clear, defensible conclusion. # Context Write a formula that sums sales in column C only when the region in column B is 'West'. # Task Produce the analysis described in the context above. Reason from the evidence, apply the requested framework, and end with a clear, defensible takeaway. # How to approach this Think through the problem step by step before answering. Work the hard parts out explicitly, then give a clear final answer. Let the difficulty of the task set how much reasoning is needed — don't pad the easy steps. # Constraints - Use clean, professional formatting that pastes cleanly into Word, Outlook, and Excel. Prefer tables and numbered steps for anything structured. - Deliver one finished, office-ready result rather than a set of options. - Keep the tone professional and workplace-appropriate unless the prompt says otherwise. - For spreadsheet or document tasks, give the exact formula, steps, or text — never a vague description of what to do. - Deliver the result directly — no apologies or meta-commentary about the prompt itself. # Output format Return only the requested output. If multiple distinct variants would clearly help, label them (e.g., "Option A", "Option B").
Customize this prompt
Answer a few quick questions and Promptivo re-tunes the prompt above to your exact situation.
Start the interview →Why this prompt works
Formulas break on the details, so the prompt forces your column layout and a concrete example of the inputs and expected result into context.
Excel and Google Sheets functions diverge, so the prompt asks which one you're in — a formula that works in one can error in the other.
Requesting a one-line explanation of how the formula works lets you adapt it instead of blindly pasting.
Using this prompt in Copilot
For an Excel formula, Copilot is a strong choice — it's especially good at Office-ready output you can finish in Word, Outlook, and Excel. Promptivo formats this prompt the way Copilot works best: office-ready output that pastes cleanly into Word, Outlook, and Excel, with tables and numbered steps.
Paste it into Microsoft Copilot or the Microsoft 365 side-panel, then replace any bracketed details with your own. Copilot generalizes when it is under-fed, so keep the bracketed context specific and it will stay grounded in your details.
Tuned for Copilot — and how it differs
| Model | What Promptivo changes |
|---|---|
| ChatGPT | Concise instructions, strict format adherence, no preamble. |
| Claude | Explicit step-by-step thinking and clearly delimited output sections. |
| Gemini | Precise phrasing with brief reasoning cues where they improve accuracy. |
| Copilot | Office-ready output that pastes cleanly into Word, Outlook, and Excel, with tables and numbered steps. |
Questions, answered
- How do I prompt AI for an Excel formula?
- Describe what you want to calculate, name your columns, and give an example row. Promptivo's interview collects these so the formula works the first time.
- Does it work for Google Sheets too?
- Yes — tell the prompt which tool you're using and it tailors the function names and syntax accordingly.
- Is Copilot good for an Excel formula?
- Yes. Copilot handles an Excel formula well thanks to its Office-ready output you can finish in Word, Outlook, and Excel, and Promptivo tunes the prompt to match — office-ready output that pastes cleanly into Word, Outlook, and Excel, with tables and numbered steps. Paste it into Microsoft Copilot or the Microsoft 365 side-panel.