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.0670.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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=510007