Combining MAX and ROUNDUP

Hi All,

Here is what I am trying to accomplish:

I have a project in which I need a quantity of 123 'widgets.'
These 'widgets' come in cases of 100.
Need a formula that will return the value of 200, when comparing 123 and 100.

Any and all help is greatly appreciated.


/twg

123 in A1

100 in B1

Try:

=CEILING(A1,B1)