Forum Discussion

FNCoreyP's avatar
FNCoreyP
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 ...
  • OliverScheurich's avatar
    Sep 12, 2023

    FNCoreyP 

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

     

    An alternative could be with COUNTIF.

Resources