I need help with the correct formula:

multiple IF statements?

if A2="X" then yield "0"
if A2 is between 0.2 and 0.4, then yield "1"
otherwise, yield "2"

Can someone help?

Thanks very much!


--
tsammons
------------------------------------------------------------------------
tsammons's Profile: http://www.excelforum.com/member.php...o&userid=30335
View this thread: http://www.excelforum.com/showthread...hreadid=533804