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?