posted
I am just trying to put "Y" or "N" in a column based on a value in a different column. Ie, if column P is P then I want it to put a Y in column O
My formula works and is: =IF(P2="P","Y","N")
However, I want to actually to say if column P is "P" OR "U", then I want to put a "Y" in O, otherwise a "N."
The only formula I can think of based on my web searches is =IF(P2="P","Y","N", IF(P2="U","Y","N")), but that doesn't work. I must be doing something simple and wrong here. Any ideas?
* I have also tried putting in OR instead of the second IF, but it still says I have too many arguments.
Posts: 2445 | Registered: Oct 2004
| IP: Logged |