Forum Discussion

janetm126's avatar
janetm126
Brass Contributor
Jun 03, 2022
Solved

Formula Trouble

I have a range of cells (C5:C31) in which a numeric value can be placed.  If 3 or more of these cells contain >=20, I want another cell to return "Warning".  I am far from an expert, but I've tried a...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jun 03, 2022

    janetm126 

    =IF(COUNTIF($C$5:$C$31,">="&20)>=3,"Warning","")

    You can try this formula.

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jun 03, 2022

janetm126 

=IF(COUNTIF($C$5:$C$31,">="&20)>=3,"Warning","")

You can try this formula.

 

janetm126's avatar
janetm126
Brass Contributor
Jun 03, 2022
>3! Thank you! I could not figure out how to add that in! I appreciate you so much.

Resources