numbers from two groups
1 Topic
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 and 350 mg. Example: Patient requires 1780 mg, so would need 3 x 500 mg plus one 350 mg vial. What would the formula look like? - Thanks in advance for any help! Kind regards HolgiSolved5.8KViews0likes16Comments