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!