Formula with IF

[Roxie]

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?

 

[Billy Liddel]

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]

Wow, I have no idea what a CEILING function is.

Use the CEILING function.
--
David Biddulph




.

 

[Roxie]

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