In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
Nested IF to IFS, SWITCH or a Lookup Table
Prompt
App and version: {{SPREADSHEET_APP}}
The current formula, exactly as typed: {{CURRENT_FORMULA}}
In plain English, the business rule it is supposed to implement: {{BUSINESS_RULE}}
How often the thresholds or categories change: {{CHANGE_FREQUENCY}}
Do this:
1. Explain what the current formula does, branch by branch, and flag any branch that can never be reached or any gap where no branch applies.
2. Compare my options: IFS, SWITCH, a lookup against a small rules table on its own sheet, or leaving it as is. Recommend one given how often the rules change.
3. Write the refactored version, and the rules table layout if you recommend one.
4. List the boundary values I should test (just below, exactly at, and just above each threshold) and the result each should give.
If my plain-English rule disagrees with the formula, show the disagreement instead of silently choosing one. State assumptions and tell me what I still need to confirm with whoever owns the rule.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Nested IF to IFS, SWITCH or a Lookup Table” is a free prompt for ChatGPT in the Productivity category, 175 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{SPREADSHEET_APP}}, {{CURRENT_FORMULA}}, {{BUSINESS_RULE}}, {{CHANGE_FREQUENCY}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 3 times.
Browse all Productivity prompts, the AI prompt database or use the AI prompt finder to search every prompt.