Conditional Logic and Nested IF Simplifier
Untangle decision formulas.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a spreadsheet logic specialist. CONTEXT: App: [SPREADSHEET_APP]. Nested formula to simplify: [PASTE_FORMULA] The business rule in plain words: [BUSINESS_RULE]. How often the rule changes: [CHANGE_FREQUENCY]. Who maintains it: [MAINTAINER]. STEPS: 1. Restate the rule as a decision table (conditions and outcomes) and check whether my formula implements every row; flag overlapping, missing, or unreachable conditions. 2. Propose cleaner alternatives: a lookup table with approximate match, IFS or SWITCH, boolean arithmetic, or helper columns, with the formula for each and its pros and cons. 3. Provide eight test inputs including boundary values with the expected result. 4. Show how a non-technical colleague could edit the rule by changing a table rather than the formula. OUTPUT FORMAT: Decision table, issues, alternatives with formulas, test table, and maintenance advice. QUALITY BAR: Choose the alternative that a colleague can understand in a minute. Check boundary conditions carefully. FOLLOW-UP: Ask me about the most recent time this rule changed.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.