How would I do this: IF A1="N" then I need A2 and A3 to="N/A
P Paul Sheppard Oct 12, 2005 #2 pknivens said: How would I do this: IF A1="N" then I need A2 and A3 to="N/A" Click to expand... 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"
pknivens said: How would I do this: IF A1="N" then I need A2 and A3 to="N/A" Click to expand... 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"
P pknivens Oct 12, 2005 #3 Perfect. Just what I needed. I was making it to complicated. I figured it would be something simple like that. Thanks again.
Perfect. Just what I needed. I was making it to complicated. I figured it would be something simple like that. Thanks again.
