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),I F(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" wrote:

Possibly:

=if(D3*.067<=.2,"0.2 mg",if(D3*.067.3,"0.3 mg","0.2-0.3 mg"))

--
Regards,
Tom Ogilvy


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?