If formula problem -

Hi guys,

I am stuck again and back where I have always found my answers thanks to you guys.

So here is the problem. In the attached file - I need the "Total Case" [column H] automated so that there is no manual entry on the form. The total case is dependent upon the "Quantity Ordered" [column D]. And the quantity per case is dependent upon "Size" [Column C].

Basically if the size is below (<) 500 then there are 24 quantities in a case. If the size is 500 & above then there are 12 quantities in a case.

For example if the "Size" is 100 then there will be 24 quantities in a case. So if the "Quantity Ordered" is 96 and the "Size" is 100, then the total case will be 4 cases (96 divided by 24).. Likewise if the "Size" is 1000 (remember 12 quantities in a case for 500 quantities & above) and the "Quantity Ordered" is 96 then the result will be 8 cases (96 divided by 12).

Basically I want that Column H under "Total Case" to be automated. Also I would like to note that Column C below "Size" is a drop-down menu.

P.S = If the value in Column C is "BULK" from the drop-down menu then the Value under "Total Case" needs to be Zero or Blank.

How can I put a function so that this entire thing is automated.

Please help! I am stuck ahead of a brick wall.

THANKS a lot in advance!

May be this......

In H12.....

=IF(D12="","",IF(C12<500,D12/24,D12/12))

and then drag down.

Try this......

=IF(D12="","",IF(C12="BULK","ZERO",IF(C12<500,D12/24,D12/12)))

Or

=IF(D12="","",IF(C12="BULK","Nil",IF(C12<500,D12/24,D12/12)))

Glad to help you. Thanks for the feedback.
If that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.