Forum Discussion

Holgi's avatar
Holgi
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
  • tauqeeracma's avatar
    tauqeeracma
    Oct 31, 2019

    Hi Holgi 

     

    With the help of below Nested If formulas you can achieve your requirements:

     

    For 500Mmg =IF(MOD(B3,500)=0,B3/500,IF(MOD(B3,500)>MOD(B3,350),ROUNDDOWN((B3/500),0),1))

    For 350mg (=IF(D3*500>=B3,0,IF(MOD(B3,350)=0,B3/350,IF(MOD(B3,500)>MOD(B3,350),1,ROUNDDOWN(B3/350,0))))

     

     

    A sample file is also attached for your reference, hope it will help you.

     

    In case you need some tweak in the formula please let me know.

     

    Thanks

    Tauqeer

     

Holgi's avatar
Holgi
Copper Contributor
Nov 04, 2019

Riny_van_Eekelen 

Hi Riny,

Thanks so much, this is extremely helpful for me - the waste calculation is very important and it seems to work great with your matrix!

Kindest regards,

Holgi

tauqeeracma's avatar
tauqeeracma
Iron Contributor
Nov 05, 2019

Hi Holgi 

 

Ideally, solutions suggested by Riny_van_Eekelen deserves to be marked as 'Best Response'.

 

Thanks

Tauqeer

Resources