Hatrack River Forum: The super duper easy excel mayfly

This is topic The super duper easy excel mayfly in forum Books, Films, Food and Culture at Hatrack River Forum.

To visit this topic, use this URL:
http://www.hatrack.com/ubb/main/ultimatebb.php?ubb=get_topic;f=2;t=055963

Posted by lem (Member # 6914) on :

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.

Posted by scifibum (Member # 7625) on :

=IF(OR(P2="P",P2="U"),"Y","N")

(untested)

Posted by scifibum (Member # 7625) on :

BTW - modification of the one you tried:

=IF(P2="P","Y",IF(P2="U","Y","N"))

Posted by Lisa (Member # 8384) on :

Is the column you're looking at all single characters? If so, try this:

=IF(OR(B1="p",B1="u"),"y","n")

Edit: or what scifibum said.

Posted by lem (Member # 6914) on :

Thanks! You guys/girls are teh awesome!