Ill do the C2 one first.
C2: =IF(A2=1;"YES";IF(A2=2;"NO";IF(A2=3;"YES";IF(A2=4; "NO";""))))

So i go to Cell C2 then click on the fx tab - That then brings up a
menu, Called insert Function. So i then Pick the IF function, then
click ok, This brings up a Function Arguments box and then what??? So
dizzy...lol


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