complex (for me) functions

New Contributor

I would like to set up a cell that looks at 4 other cells and returns an answer of TRUE if 2 or more of those cells contain "yes" from a drop down list and FALSE if fewer than2 of those cells contain "yes" from a drop down list. I'm struggling with the syntax of the function to enter in the result cell. Is this doable?

 

Thanks.

2 Replies

@jen25 

=COUNTIF(C2:F2,"yes")>=2

Maybe with this formula as shown in the attached file. WAHR means TRUE in german and the dropdowns are in cell C2:F2. 

@Quadruple_Pawn I wound up using a countif function imbedded in an if function so that I could get a TRUE/FALSE to return to the cell. Thanks for putting me on the right track!