I need help on automated updating of cell C2, currently im using IF ELSE statement which is limited at 7 nested if functions.
Total Quantity Sold is updated from another file.
I have several item from several shipment each with varying cost price.
what the nested if else statement is doing is that, cost price start with shipment one, once quantity sold has exceeded quantity from shipment 1, it will update to the cost price of shipment 2. Once quantity sold has exceeded quantity purchase from shipment 1 and 2, it will take the cost price of shipment 3. Please assit on how to do away on the nested If else statement. thanks!
Solved by E. U. in 29 mins