+ Reply to Thread
Results 1 to 5 of 5

IF function problem

  1. #1
    Registered User
    Join Date
    04-19-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2003
    Posts
    20

    IF function problem

    I hope this isn't a second posting of this. 1st one said not logged in.

    I want to compare two columns of information with two other columns of supposedly the same information to determine where/if they differ


    I've used the "If" function to compare two columns of information row by row with the formula =if(A3=A6,"Y","N") in cell C3.

    Can you advise how to modify the formula to compare two columns with two other columns such as =if(A3=A6 & A4=A7,"Y","N") I know that doesn't work
    I 'm sure there's a more efficient way but that's my level at present.

    Thanks for any help

  2. #2
    Registered User
    Join Date
    04-17-2012
    Location
    Sherbrooke
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: IF function problem

    Try =if(and(a3=a6,a4=a7),"Y","N")

  3. #3
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: IF function problem

    If you have multiple conditions that you want met at the same time, then in your case:

    =IF(AND(A3=A6,A4=A7),"Y","N")

    If it is enough that just one of the 2 conditions are met, then you replace the AND() with OR().
    Sincerely
    Søren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

  4. #4
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: IF function problem

    Hi,

    Try this

    Please Login or Register  to view this content.

    Thanks,

    Bonny Tycoon



    **If I was able to help please click the small star icon at the bottom left of my post **

  5. #5
    Registered User
    Join Date
    04-19-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: IF function problem

    Quote Originally Posted by badaza View Post
    Try =if(and(a3=a6,a4=a7),"Y","N")
    Thank You badaza, worked a treat.
    Thank you all for speedy replies.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1