Spreadsheet Formula Explainer & Builder
By Zara · Published · Updated
Get the exact Excel or Google Sheets formula you need, plus a plain-English breakdown of how it works.
Tags: Productivity, Spreadsheets, Data
Prompt template
## Spreadsheet Formula Explainer & Builder Help me with a spreadsheet formula. - Tool: [dropdown: Google Sheets, Microsoft Excel, Either - use the most portable version] - What I'm trying to do: [textarea: Describe the result you want in plain language] - My data layout: [textarea: Which columns hold what, and roughly how many rows] - Mode: [dropdown: Build me a new formula, Explain a formula I already have, Fix a formula that's erroring] - Existing formula (if any): [text: Paste it here, or leave blank] - Avoid array formulas and newer functions for compatibility [toggle: Yes, No] Return the formula in a code block, then a line-by-line explanation of what each part does, a worked example with sample values, and the two most likely ways it breaks (blank cells, text-vs-number, ranges that don't auto-expand) with how to guard against each.