FacebookTwitter
Hatrack River Forum Post New Topic  Post A Reply
my profile login | register | search | faq | forum home

  next oldest topic   next newest topic
» Hatrack River Forum » Active Forums » Books, Films, Food and Culture » The super duper easy excel mayfly

   
Author Topic: The super duper easy excel mayfly
lem
Member
Member # 6914

 - posted      Profile for lem           Edit/Delete Post   Reply With Quote 
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 | Report this post to a Moderator
scifibum
Member
Member # 7625

 - posted      Profile for scifibum   Email scifibum         Edit/Delete Post   Reply With Quote 
=IF(OR(P2="P",P2="U"),"Y","N")

(untested)

Posts: 4287 | Registered: Mar 2005  |  IP: Logged | Report this post to a Moderator
scifibum
Member
Member # 7625

 - posted      Profile for scifibum   Email scifibum         Edit/Delete Post   Reply With Quote 
BTW - modification of the one you tried:

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

Posts: 4287 | Registered: Mar 2005  |  IP: Logged | Report this post to a Moderator
Lisa
Member
Member # 8384

 - posted      Profile for Lisa   Email Lisa         Edit/Delete Post   Reply With Quote 
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.

Posts: 12266 | Registered: Jul 2005  |  IP: Logged | Report this post to a Moderator
lem
Member
Member # 6914

 - posted      Profile for lem           Edit/Delete Post   Reply With Quote 
Thanks! You guys/girls are teh awesome!
Posts: 2445 | Registered: Oct 2004  |  IP: Logged | Report this post to a Moderator
   

Quick Reply
Message:

HTML is not enabled.
UBB Code™ is enabled.
UBB Code™ Images not permitted.
Instant Graemlins
   


Post New Topic  Post A Reply Close Topic   Feature Topic   Move Topic   Delete Topic next oldest topic   next newest topic
 - Printer-friendly view of this topic
Hop To:


Contact Us | Hatrack River Home Page

Copyright © 2008 Hatrack River Enterprises Inc. All rights reserved.
Reproduction in whole or in part without permission is prohibited.


Powered by Infopop Corporation
UBB.classic™ 6.7.2