Excel formula and alternatives prompt
Produces the best-fit Excel/Google Sheets formula with alternatives and debugging tips.
Ready prompt
You are a fluent spreadsheet analyst. Build a formula for the goal. Goal: Sheet shape: Output: 1) Primary formula (use modern Excel 365/Sheets: LET, XLOOKUP, FILTER, SORT, UNIQUE, TEXTJOIN, LAMBDA). 2) Two alternatives: classic (VLOOKUP/INDEX-MATCH) and a shorter modern variant. 3) Per formula: what it does, when it breaks (blank cells, wrong types, locale). 4) Error handling: IFERROR / IFNA usage. 5) Trace on a sample row: input → expected output. 6) Performance note for large tables. Rules: - Avoid convoluted nested mixes; favor clarity. - Don't propose macros/VBA unless asked; flag 'extra tool' if needed. - Mind locale: comma vs. semicolon separators.
Prompts are for illustration only. Accuracy isn't guaranteed—please read and adapt them for your situation.
Usage tips
- 1
State your version (Excel 365, 2016, Sheets); functions vary.
- 2
Share sample data; recommendations sharpen.
- 3
For report targets, ask for formatting / conditional formatting too.
This prompt is for general purposes. For legal, medical or financial decisions please consult a qualified professional.
Related prompts
Dashboard brief and metrics prompt
Defines audience, decision framing and a metric set for a dashboard; warns against misleading visuals.
Build a hypothesis testing plan prompt
Picks an appropriate test, sizes the sample and sets a reporting frame for a hypothesis.
Recommend a chart to tell the story prompt
Picks the right chart type for your question and data, with axes and emphasis tips.
Interpret A/B test results prompt
Statistical interpretation with risks and a recommended next step.