complex (for me) functions

%3CLINGO-SUB%20id%3D%22lingo-sub-3238977%22%20slang%3D%22en-US%22%3Ecomplex%20(for%20me)%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3238977%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20set%20up%20a%20cell%20that%20looks%20at%204%20other%20cells%20and%20returns%20an%20answer%20of%20TRUE%20if%202%20or%20more%20of%20those%20cells%20contain%20%22yes%22%20from%20a%20drop%20down%20list%20and%20FALSE%20if%20fewer%20than2%20of%20those%20cells%20contain%20%22yes%22%20from%20a%20drop%20down%20list.%20I'm%20struggling%20with%20the%20syntax%20of%20the%20function%20to%20enter%20in%20the%20result%20cell.%20Is%20this%20doable%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3238977%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3239006%22%20slang%3D%22en-US%22%3ERe%3A%20complex%20(for%20me)%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3239006%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1321353%22%20target%3D%22_blank%22%3E%40jen25%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DCOUNTIF(C2%3AF2%2C%22yes%22)%26gt%3B%3D2%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EMaybe%20with%20this%20formula%20as%20shown%20in%20the%20attached%20file.%20WAHR%20means%20TRUE%20in%20german%20and%20the%20dropdowns%20are%20in%20cell%20C2%3AF2.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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!