Claude 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 Claude · 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 You reason carefully on your own. Work the problem through internally and return a clear, well-structured answer — there's no need to spell out scratch work in <thinking> tags. Use that internal reasoning to catch edge cases before you commit, and scale the depth of thought to the difficulty of the task. # Constraints - Use clear markdown sections and headings. Favor well-structured, thorough output over terse output. - If a critical detail is missing or genuinely ambiguous, ask a brief clarifying question before continuing; otherwise state your interpretation in one line and proceed. - Do not open with "I'd be happy to help" or any variant. Just start. - Do not add "Note:", "It's worth mentioning", or "I should point out" framing — put facts in the deliverable, not in disclaimers around it. - Treat clearly benign tasks as safe and complete them directly. - 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 Claude
For an Excel formula, Claude is a strong choice — it's especially good at careful step-by-step reasoning and cleanly structured long-form writing. Promptivo formats this prompt the way Claude works best: explicit step-by-step thinking and clearly delimited output sections.
Paste it into claude.ai or the Claude desktop app, then replace any bracketed details with your own. Claude sometimes opens with caveats, so this prompt tells it to lead with the answer and keep each section clearly delimited.
Tuned for Claude — 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 Claude good for an Excel formula?
- Yes. Claude handles an Excel formula well thanks to its careful step-by-step reasoning and cleanly structured long-form writing, and Promptivo tunes the prompt to match — explicit step-by-step thinking and clearly delimited output sections. Paste it into claude.ai or the Claude desktop app.