SOLVED

# Trying to figure out a specific IF, THEN rule

Copper Contributor

# Trying to figure out a specific IF, THEN rule

What I'm aiming for is a simple, (If H5 through H10 all show "yes", then D4 should show "yes". If any cell H5 down through H10 show a "no", then D4 should show "no".)

I've tried a few things but have been running into a brick wall. Anyone have an idea?

Thank you!

Corey Piazza

4 Replies

# Re: Trying to figure out a specific IF, THEN rule

=IF(AND(H5:H10="yes"),"yes","no")

# Re: Trying to figure out a specific IF, THEN rule

That yields a "There's a problem with this formula."
best response confirmed by FNCoreyP (Copper Contributor)
Solution

# Re: Trying to figure out a specific IF, THEN rule

=IF(COUNTIF(H5:H10,"yes")=6,"yes","no")

An alternative could be with COUNTIF.

# Re: Trying to figure out a specific IF, THEN rule

Thank you, OliverScheurich, that worked!
1 best response

Accepted Solutions
best response confirmed by FNCoreyP (Copper Contributor)
Solution

# Re: Trying to figure out a specific IF, THEN rule

=IF(COUNTIF(H5:H10,"yes")=6,"yes","no")

An alternative could be with COUNTIF.