math formula with upper and lower limits on data but also ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

sorry if this is too simple.
I would like to write a formula which will calculate a dose range of
medication based on patient's weight. I would like the data displayed such
that it would read (0.2-0.3 mg). This formula needs to have upper an lower
limits on the dose. THe dose cannont be lower than 0.2 nor higher than 3,
but all values in between should show.

here is what I have so far. I am unable for figure out how to impose the
upper limit. D3 location of user defined patient weight.


=CONCATENATE(IF(PRODUCT(0.067,D3)<=0.2,VALUE(0.2),IF(PRODUCT(0.067,D3)>0.2,VALUE(PRODUCT(0.067,D3))&"-"&CONCATENATE(IF(PRODUCT(0.1,D3)<=0.3,VALUE(0.3),IF(PRODUCT(0.2,D3)>0.3,VALUE(PRODUCT(0.2,D3))))))))


I had one suggestion but it did not provide the correct result:

Tom Ogilvy said:
Possibly:

=if(D3*.067<=.2,"0.2 mg",if(D3*.067>.3,"0.3 mg","0.2-0.3 mg"))
Click to expand...


Thanks for the suggestion. The formula will not provide the true value for
results that are > 0.2 but less than 3. I would like to have the result show
as a range of true values between 0.2 and 3 but if the values are < 0.2 then
0.2-0.3 should be the out put and if the values are > 3, then 2-3 should be
the output.

any insight?
 
I am not sure if you stated you question clearly. I would have given the
response of the previous reply, but if you mean the calculation is
performed for results between 0.2 and 0.3 try

=IF(D3*0.067<=0.2,"0.2 mg",IF(D3*0.067>0.3,"0.3 mg",ROUND(D3*0.067,2)&"
mg"))

the round funcation can be removed or adjusted depending on the dp you
require. currently its 2

Regards

DAv
 
see response posted a few minutes ago to your original question in
excel.programming
 
Back
Top