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.
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.
