Forum Discussion

Copper Contributor

Sep 12, 2023

Solved

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 ...

excel

Formulas and Functions

office 365

OliverScheurich
Sep 12, 2023
FNCoreyP
=IF(COUNTIF(H5:H10,"yes")=6,"yes","no")

An alternative could be with COUNTIF.

OliverScheurich

Gold Contributor

Sep 12, 2023

FNCoreyP

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

An alternative could be with COUNTIF.

FNCoreyP
Copper Contributor
Sep 12, 2023
Thank you, OliverScheurich, that worked!