Resolve overlapping request rules with explicit priority
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.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View 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.
No account. No upload. Just try it.