Rounding to a cell value

[Bagsy Baker]

I have a calculated value in cell B2. I have Box Quantity in cell C2. I want the value in D2 to be a Roundup multiple of C2.

So....
If B2 = 17.74
C2 = 10
Then D2 should equal 20

I can't believe I'm having issues with this, assuming it's because it's a Friday afternoon here...

Thanks for your help,
Bagsy

 

[Saba Sabaratnam]

You could use the following formula:

=CEILING(b2,c2)

Kind regards

Saba

 

[mart37]

You can use MROUND or CEILING.MATH

 

[Bagsy Baker]

Thank you! I knew there had to be a simple solution.