If / Then Question
 

How would I do this:

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


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

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

Perfect. Just what I needed. I was making it to complicated. I
figured it would be something simple like that. Thanks again.


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