Refactor a nested IF policy into a maintained rule table
Build D2:F9 using three separate column seeds. D retains the frozen nested-IF policy: negative quantities are Review quantity; nonnegative quantities below 5 are Below minimum; the inclusive minima 5,10,25,50 select flat rates 12,10,8,6. E reads the current four-row J2:K5 policy using the largest minimum at or below each quantity, regardless of table order, with the same negative/below-minimum labels. F returns Same when both typed results agree and Changed otherwise. Fill D, E and F separately; every result needs its own copied formula. Quantities and unique nonnegative minima are whole numbers within ±1,000,000 (minima cannot be negative); current flat rates are nonnegative whole-cent numbers up to 1,000,000. These are flat rates, not progressive totals.
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
Build D2:F9 using three separate column seeds. D retains the frozen nested-IF policy: negative quantities are Review quantity; nonnegative quantities below 5 are Below minimum; the inclusive minima 5,10,25,50 select flat rates 12,10,8,6. E reads the current four-row J2:K5 policy using the largest minimum at or below each quantity, regardless of table order, with the same negative/below-minimum labels. F returns Same when both typed results agree and Changed otherwise. Fill D, E and F separately; every result needs its own copied formula. Quantities and unique nonnegative minima are whole numbers within ±1,000,000 (minima cannot be negative); current flat rates are nonnegative whole-cent numbers up to 1,000,000. These are flat rates, not progressive totals.
No account. No upload. Just try it.