If the statement

cansevin
cansevin used Ask the Experts™
on
In cell H3, I3, J3 and K3 I have either a "Yes" or "No". In Cell L3 I want it to say "Yes" if any of the 3 say "Yes". If none say "yes" I want cell L3 to say "no". Any idea?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
in L3 cell, enter

=IF(AND(H3 ="yes",I3="yes",J3="yes"),"yes","no")
NorieAnalyst Assistant
Commented:
Try this.

=IF(COUNTIF(H3:J3, "yes")>0, "yes", "no")
NorieAnalyst Assistant

Commented:
cansevin

The formula in the accepted solution will only return 'yes' if every cell in H3:J3 has 'yes' in it.

Is that what you wanted?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial