• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Another formula question

Jaimee001

Jaimee001

Member
This has certainly been my week for questions. The one for today I actually had figured out earlier in the week but my brain for some reason is not working right now.

I have a file that contains acct number, code 1 and code 2. I need to set up a 4th column with a Yes/No function. If code 1 and code 2 are the same then Yes and if they are different then No....I cannot for the life of me remember how I did this.....YIKES

Here is the link: http://speedy.sh/tnfCv/Yes-no-example.xlsx

Thanks in advance!!!!! (and thankfully it's FRIDAY!!!)
 
Jaimee

Try this in D2:

=IF(B2=C2,"Y","N")

copy down


If you just wanted a True/False you can simplify to:

=B2=C2


ps: Don't worry about asking questions, We had a member about 18 months ago who asked 31 questions in 1 week
 
You must log in or register to reply here.
Back
Top