pknivens Wrote:
How would I do this:

IF A1="N" then I need A2 and A3 to="N/A"

Hi pknivens

In A2 and A3 use this formula =IF(A1="N","N/A",""), this will return
blank if A1 is not N, if you want it to return something different then
change the "" to "Whatever you want"


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=475311