Link to home
Start Free TrialLog in
Avatar of cansevin
cansevin

asked on

If the statement

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?
ASKER CERTIFIED SOLUTION
Avatar of traoher
traoher

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Norie
Norie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Norie
Norie

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?