Forum Discussion

Copper Contributor

Oct 31, 2019

Solved

Numbers calculation

Hi all, I'm new to this forum and have the following problem to solve: I need to have Excel automatically calculate how many vials of two sizes a patient needs to get dosed. The vial sizes are 500 a...

Numbers from two groups

Holgi

Copper Contributor

Oct 31, 2019

tauqeeracma

Hi Tauqeer,

Thanks so much, thats very helpful! Your help is very much appreciated!

Have a good rest of the day!

Kindest regards,

Holgi

PReagan

Bronze Contributor

Oct 31, 2019

Hello Holgi,

Are you seeking a combination of 500mg and 350mg vials such that the waste is minimized?

For example, say the prescribed amount is 700mg. Would you require a 500mg vial and a 350mg vial (150mg waste) or two 350mg vials (0mg waste).