IF statement looking in three cells

[abellad]

I am trying to write a simple IF statement, basically I want the statement to look at three cells and if any of the cells have a NO then the formula should return a NO or it should return a YES. This is what I have been using but it does not work.

=IF(AND(BF2="NO", BG2="NO", BH2="NO"),"NO","YES")

Any ideas?

Thanks in advance

 

[jimrward]

Try changing the AND to OR

 

[abellad]

You Sir are a star. Thank you!

 

[jimrward]

Nae bother from across the water

 

[jtakw]

Hi,

Since the cells you're testing is contiguous, you can also do it this way:

=IF(COUNTIF(BF2:BH2,"NO"),"NO","YES")