| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Benefits many people - Question | Excel Discussion (Misc queries) | |||
| Possibly a loaded question, but I think | Excel Discussion (Misc queries) | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Linear Mode
