Equation for inventory

[Holmes89]

Looking for a IF/Then formula to add to my spreadsheet.

The inventory removal will be done manually but I would like it to have a cascade effect from cases into 6 packs into individual. On the sheet I have 24 individual bottles of heineken being removed. I only have 15 individuals in the starting inventory section. I would like it to break down two 6 packs in order to be able to take the 24 individual bottles (total of 27)(15+12(for the 2 6 packs). I would then like it to adjust the 6 packs to -1 as I only had 1 6 pack, to do that it would adjust the cases from 1 to 0 as I would have used that case. The only equations on the entire excel sheet are in the total inventory so do not worry about that.

 

[Fluff]

Duplicate to: If/then cascade effect for inventory spreadsheet.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.