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

     

PReagan's avatar
PReagan
Bronze Contributor
Nov 02, 2019

Holgi 

 

Is a formula necessary or would a VBA code to automatically run Solver suffice?

Holgi's avatar
Holgi
Copper Contributor
Nov 03, 2019

Hi PReagan 

As I am not familiar with VBA codes, I would prefer a formula. Thanks in anticipation for your continued support!

Kindest,

Holgi