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.