Match formula?

  • Thread starter Thread starter Sharon
  • Start date Start date
S

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.
 
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.
 
That is how I interpereted it as well, does my formula do something
incorrect?

Dan E

Myrna Larson said:
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.
Click to expand...
 
Back
Top