I entered the code into Cell C2 then Pressed Enter. Now it pops up a
message saying ERROR- "The Formula you type contains an error"

This was the Code i entered into Cell C-

=IF(A2=1;"YES";IF(A2=2;"NO";IF(A2=3;"YES";IF(A2=4; "NO";""))))

I dont care about the YES NO things at the moment. I would be happy if
it worked. You have been alot of help and i thank you so much, if its
not to much of a problem, could you try this and see if it works, its
not working for me at all.


--
joelbeveridge
------------------------------------------------------------------------
joelbeveridge's Profile: http://www.excelforum.com/member.php...o&userid=37045
View this thread: http://www.excelforum.com/showthread...hreadid=567717