Nested IF/AND/OR formula

**livmunro** · 12-03-2013, 12:48 PM

I have 4 columns and I want to do a formula to produce yes or no based on certain conditions being met.

1st condition to return yes - IF E2 contains Bridge AND F2 is in List1 (named range of bridge types)
2nd condition to return yes - OR E2 = Not Bridge AND F2 is in List2 AND AV contains #N/A ISNA(AV1)?
If neither of these conditions is met return No.

I've tried using IF/AND/OR as nested formulas along with INDEX, MATCH, COUNTIF... but nothing will work.
Thanks in advance for your help,
Liv

**daffodil11** · 12-03-2013, 01:17 PM

=IF(OR(AND(E2="Bridge"),COUNTIF(LIST1,F2)>0),AND(E2="Not Bridge",COUNTIF(LIST2,F2))),"YES","NO")

**daffodil11** · 12-03-2013, 01:20 PM

I missed the error part.

As for the last part of condition 2, what is the cell reference? AV2 contains an error?

Maybe:

=IF(OR(AND(E2="Bridge"),COUNTIF(LIST1,F2)>0),AND(E2="Not Bridge",COUNTIF(LIST2,F2),ISERROR(AV1)),"YES","NO")