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))))))))

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))))))))

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))))))))

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))))))))

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))))))))

kenneth Wrote: [color=blue]
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



Roger,

I think there is an error. For example if D3 is say 42 your formula
would give "2.8 - 4.2 mg " which is not what Kenneth wants. I think he
wants actual value upto 3 and "2 - 3 mg" if it exceeds 3.

There is an error in my formula as well. Instead of 0.67 it should read
.067 everywhere. It should be

IF(0.067*D3<=0.2, "0.2-0.3 mg", IF(0.067*D33, "2.0-3.0
mg",TEXT(D3*0.067,"0.0")&" mg"))



A V Veerkar


--
avveerkar
------------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338
View this thread: http://www.excelforum.com/showthread...hreadid=509499

kenneth Wrote:
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?

try
IF(0.67*D3<=0.2,"0.2-0.3 mg", IF(0.67*D33, "2 - 3 mg", 0.67*D3 & "
mg"))

A V Veerkar


--
avveerkar
------------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338
View this thread: http://www.excelforum.com/showthread...hreadid=509499