Gemini 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 Gemini · 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 Be precise and literal about the requirements. Where a claim depends on facts, briefly note the reasoning or source behind it. # Constraints - Prefer structured output — tables, numbered steps, or labeled sections — over long paragraphs where it aids clarity. - Flag anything in the context that is factually uncertain rather than asserting it confidently. - Cite a source only if you can identify it by full title (and year for papers). Never fabricate a URL. - Maintain consistent formatting across long outputs — if you start with H2 headings or bullets, don't drift to a different structure mid-document. - 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 Gemini
For an Excel formula, Gemini is a strong choice — it's especially good at concise, factual output and precise instruction-following. Promptivo formats this prompt the way Gemini works best: precise phrasing with brief reasoning cues where they improve accuracy.
Paste it into gemini.google.com, then replace any bracketed details with your own. Gemini is sensitive to wording, so this prompt pins down the exact terms and structure to keep the result from drifting.
Tuned for Gemini — 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 Gemini good for an Excel formula?
- Yes. Gemini handles an Excel formula well thanks to its concise, factual output and precise instruction-following, and Promptivo tunes the prompt to match — precise phrasing with brief reasoning cues where they improve accuracy. Paste it into gemini.google.com.