+ Reply to Thread
Results 1 to 5 of 5

Needing Help with Nested IF Statement for One OR Two Column Word Answers

  1. #1
    Registered User
    Join Date
    02-16-2013
    Location
    Moose Jaw, Canada
    MS-Off Ver
    Excel 2010
    Posts
    6

    Needing Help with Nested IF Statement for One OR Two Column Word Answers

    I am working on an Excel project with no luck.

    I need to create a nested IF statement with the following criteria:

    1 - if a property is in the NE Sector or is a corner lot (yes to either)
    0 - every other combination - neither NE Sector and a Corner Lot (two no's)

    Basically, what I need is this:
    If Column A (NE_Sector) OR Column B (Corner_Lot) contain the word "YES", then a 1 is placed in the new column; 0 is placed if the criteria doesn't match "YES" with either column.

    How would a formula like this be written? I have tried every possible combination I know personally, and still am having errors. I am newer to Excel, as I imagine this is a pretty easy thing for most advanced users to understand.

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Needing Help with Nested IF Statement for One OR Two Column Word Answers

    If your first row of data was row 2 then something like this:

    =IF(OR(A2="YES",B2="YES"),1,0)

  3. #3
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Needing Help with Nested IF Statement for One OR Two Column Word Answers

    Maybe..

    =--(COUNTIF(A2:B2,"Yes")>0)
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  4. #4
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Needing Help with Nested IF Statement for One OR Two Column Word Answers

    For this one there must be more options than we could ever list here

    =--(OR(A2:B2="Yes"))

    Confirmed with CSE, naturally.

  5. #5
    Registered User
    Join Date
    02-16-2013
    Location
    Moose Jaw, Canada
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Needing Help with Nested IF Statement for One OR Two Column Word Answers

    Thank you very much!
    =IF(OR(A2="YES",B2="YES"),1,0) worked perfectly!
    I just switched A2 for NE_Sector and B2 for Corner_Lot
    I had the right idea, I was just not formatting it correctly.

    I will get better with more practice, that's for sure!

    Thank you once again for the help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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