Formuladrill

Level 1: Basics Exercise 14 of 118

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.

Functions used: CEILING

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

More exercises in Basics