- AI Business Workflows
- Text
- Beginner
- ChatGPT
- Claude
- Gemini
- Published
Excel and Google Sheets Formula Builder With a Plain-English Explanation
Writes the formula for what you want a spreadsheet to do, in both Excel and Google Sheets syntax, explains each part, and gives a test case so you can check it works.
You get: the formula in a code block per app, a part-by-part explanation, a small example table with input and expected result, and common mistakes (wrong range lock, text vs number). End…
The prompt
Act as a spreadsheet expert who explains formulas to people who do not write them every day. Build the formula I describe.
Ask me one or two short questions first if needed: the column letters or a sample of my data, and whether I use Excel or Google Sheets.
Rules:
- Give the formula in Excel and Google Sheets syntax if they differ (for example XLOOKUP vs VLOOKUP, ARRAYFORMULA, FILTER).
- Prefer the simplest formula that works. Avoid volatile functions such as INDIRECT or OFFSET unless needed, and say why.
- Handle blanks and errors with IFERROR or IF where it matters, and say what the formula returns in those cases.
- Explain each part of the formula in one line.
Output format: the formula in a code block per app, a part-by-part explanation, a small example table with input and expected result, and common mistakes (wrong range lock, text vs number). End with assumptions about my data layout.
What I want the formula to do:
{describe what you want to calculate}Tips and common edits
Describe the result in plain words with a few sample rows. Works in ChatGPT, Claude, Gemini, and Gemini inside Google Sheets; test it on the example table first.
Questions about this prompt
More like this
More in AI Business Workflows4-Week Small Business Launch Plan: $0 and Small-Budget Versions
Builds a 4-week launch plan for a product or service in a specific market, with channels and weekly tasks in a $0 version and a small-budget version.
Customer Support Macro Set for Refunds, Delays, Angry Customers and Escalation
Writes 10 ready-to-send support reply macros in your brand tone covering refunds, delays, angry customers and escalation.
Meeting Notes to Action Items, Owners and a Ready-to-Send Follow-Up Email
Turns raw meeting notes or a transcript into decisions, action items with owners and dates, open questions, and a short follow-up email you can send right after the call.
Process Transcript to Standard Operating Procedure
Converts a pasted process description or transcript into an SOP with purpose, roles, numbered steps, checklists and common mistakes.
Repetitive Task to Zapier, n8n or Make Automation Spec
Turns a repetitive task into a build-ready automation spec with triggers, AI steps, human checkpoints, failure handling and a test plan.
Standard Operating Procedure From a Screen-Recording Transcript
Turns the transcript of a recorded walkthrough into a numbered SOP with prerequisites, steps, screenshots to capture, decision points, and common mistakes, ready for a team wiki.
Spreadsheet and CSV Cleanup Report Skill (SKILL.md)
A SKILL.md that has your agent profile a messy CSV or spreadsheet, fix it in a copy with a script, and report every change so the cleaned data can be trusted.
Executive Decision Memo Builder With Options, Risks, and Recommendation
Turns a pending business decision into a one-page-style decision memo with scored options, explicit assumptions, risks, missing information, a recommendation, and next actions an executive can approve or reject.
Process Bottleneck Diagnosis and Workflow Redesign With Pilot Plan
Maps a current team workflow, finds bottlenecks and handoff failures, designs a leaner future-state process with roles and automation candidates, and outlines a low-risk pilot with success metrics.
Weekly Operating Review: KPI Variance Diagnosis and Action Plan
Analyzes weekly KPI data against targets, separates signal from noise, proposes ranked root-cause hypotheses, and produces owner-assigned actions and an escalation list for a team operating review.