Code:
--------------------
=IF(profit <=20;"1%";IF(profit<=30;"2%";IF(profit<=35;"3%";IF (profit<=60;"6%";"Error"))))
--------------------
you have to replace profit by the specific Cell e.g. A2
Simon
--
moondark
------------------------------------------------------------------------
moondark's Profile:
http://www.excelforum.com/member.php...o&userid=27390
View this thread:
http://www.excelforum.com/showthread...hreadid=470193