Resolve overlapping request rules with explicit priority
Your goal: Compare nested IF and first-match IFS on the same requests. Combine AND, OR and NOT, expose overlapping rules and change the priority in a real worksheet cell.
Full task requirements
Fill G2:G9, H2:H9, I2:I9 and J2:J9 separately from their own top seeds. B is whole age hours 0..10000, C whole impact 0..10, D repeated and E acknowledged are actual Boolean values, F is the exact text Open or Closed. M2 and M3 are whole age/impact thresholds with the same bounds; M4 is 1 Escalate-first or 2 Review-first. Urgent means NOT acknowledged AND (age >= M2 OR impact >= M3). Review means repeated OR (acknowledged AND impact >= M3). Closed always overrides all other rules. G reports whether both urgent and review match an open row. H uses genuine nested IF and I first-match IFS with an explicit Routine fallback. For open rows use the selected priority to choose Escalate or Review when both match, otherwise the sole matching rule or Routine. J compares the two written routes as a Boolean. Apply actual AND, OR and NOT in both routes. No rule inference or real-world service commitment is implied.
| # | ||||||||
|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||
| 2 | ||||||||
| 3 | ||||||||
| 4 | ||||||||
| 5 | ||||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 |
Read the thresholds and priority separately
Rules for this step
Select M2:M4. Equality meets the age or impact threshold. D and E are stored Booleans; M4 chooses which matching open-row rule wins, without changing either Boolean condition.