Match formula?

[Sharon]

Is there a formula that would return a result of YES when
column A and B have a value of YES? But if column A OR B
have any other value other than YES like NO, then the
formula would return a result of NO.

 

[Dan E]

=IF(AND(A1:B20="YES"),"YES","NO")
Array Entered (ctrl + shift + enter)

Dan E

 

[Myrna Larson]

That formula is equivalent to the "normal" (non-array) formula

=IF(COUNTIF(A1:B20,"YES")=40,"YES","NO")

i.e. it tests whether all cells in the entire range contain YES, rather than returning one
result for each row. I didn't interpret the question that way, but perhaps it is correct.

 

[Dan E]

That is how I interpereted it as well, does my formula do something
incorrect?

Dan E

That formula is equivalent to the "normal" (non-array) formula

=IF(COUNTIF(A1:B20,"YES")=40,"YES","NO")

i.e. it tests whether all cells in the entire range contain YES, rather than returning one
result for each row. I didn't interpret the question that way, but perhaps it is correct.