Choose a rate from quantity bands
Fill E2:E4 with the rate for each quantity in D2:D4. Choose the largest minimum quantity less than or equal to the query, regardless of table order. Return Below minimum when no band qualifies and Review quantity for negative inputs. This selects one flat rate, not a progressive charge.
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 E2:E4 with the rate for each quantity in D2:D4. Choose the largest minimum quantity less than or equal to the query, regardless of table order. Return Below minimum when no band qualifies and Review quantity for negative inputs. This selects one flat rate, not a progressive charge.
No account. No upload. Just try it.