Brilliant!
Sorry for the post in 2 places.

"Roger Govier" wrote:

Hi Kenneth

If I understand you correctly then
=IF(D3*0.067<0.2,"0.2 - 0.3 mg",IF(D3*0.0673," 2.0 - 3.0 mg",
TEXT(D3*0.067,"0.0")&" - "&TEXT(D3*0.1,"0.0")&" mg"))
will provide your requirements.

--
Regards

Roger Govier


"kenneth" wrote in message
...
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?


"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


"kenneth" wrote in message
...
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,V
ALUE(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))))))))