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

1. ## 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. ## 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. ## Re: Needing Help with Nested IF Statement for One OR Two Column Word Answers

Maybe..

=--(COUNTIF(A2:B2,"Yes")>0)

4. ## 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. ## 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.

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

#### 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