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