Thank you so much! That worked perfectly. I appreciate the help.

"Billy Liddel" wrote:

Try this

=IF(E36<B36,ROUNDUP((B36-E36)/24,0))*24

If you order in cases then remove the *24 at the end

HTH
Peter

"Roxie" wrote:

I have a liquor inventory worksheet that I am trying to get to give me an
order amount based on pars. I have this:

On Hand Liquor is E
Par is column B

I currently have this as a formula:

=IF(E36<B36,24,0)

This part works and I order 24. The problem I have is ordering beer. It
comes in cases which are 24 to a case. So, I need to order 24, 48, 96 etc. If
B36 is 24 but <48 I will have to order 48. If it is 48 but <72 I need to
order 72.

Can anyone help me with this?