Combining MAX and ROUNDUP

[thewiseguy]

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

 

[VBA Geek]

use CEILING

Excel 2013/2016
	A	B
1	123	200
Sheet1

Cell Formulas
Range	Formula
B1	=CEILING.MATH(A1,100)

 

[thewiseguy]

use CEILING

Excel 2013/2016
	A	B
1	123	200
Sheet1

Cell Formulas
Range	Formula
B1	=CEILING.MATH(A1,100)

Thanks for the response. This is great, however if the widgets come in a case qty of something other than 100, the result will not be accurate.

Is there a way to alter this formula so that the roundup is based on quantities of whatever the case comes in?

Example:

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

 

[Aladin Akyurek]

@ thewiseguy

Have you tried to replace 100 in the formula VBA Geek gives with B1?

=CEILING.MATH(A1,B1)

 

[thewiseguy]

@ thewiseguy

Have you tried to replace 100 in the formula VBA Geek gives with B1?

=CEILING.MATH(A1,B1)

that was it. excellent, thanks so much to everyone.