I have a series of volumes of vaccine that I need to order regulary ranging from 40ml to 1750ml the vaccines come in bottles of 250ml, 100ml and 50ml.
The quantities are listed in column H3 to H36 and the bottle sizes are listed J2 to L2.
What formula can I put in so that it automatically calculates how many of each bottle I will require? Also taking into consideration that if the quantity is 40ml I will nedd a 50ml bottle or if 80ml I will need a 100ml bottle etc??
Please help!!
The quantities are listed in column H3 to H36 and the bottle sizes are listed J2 to L2.
What formula can I put in so that it automatically calculates how many of each bottle I will require? Also taking into consideration that if the quantity is 40ml I will nedd a 50ml bottle or if 80ml I will need a 100ml bottle etc??
Please help!!