Order in full cases
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
The warehouse only ships full cases, and the case size is in F1. Round each quantity needed up to the next full case and put the units to order in C2 and C3. A quantity that already fills whole cases stays the same.
What this exercise teaches
CEILING rounds up to a multiple, FLOOR rounds down and MROUND goes to the nearest one. A value that is already a multiple, such as 36 with a case size of 12, is left alone.
A hint if you get stuck
CEILING(number, multiple) rounds up to the next multiple. ROUNDUP(B2/$F$1,0)*$F$1 gives the same result.
Try it now, free, no account needed
Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.
Open this exercise