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

Try this. I don't know if your range should include the number 0.2 and 0.4,
but here it is exluding those:

=IF(A2="X",0,IF(A20.2,IF(A2<0.4,1,2),2))

There's probably a better way to do it, but I hope that works.

Mark

"tsammons" wrote:


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