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 07, 2022
    OliverScheurich, what if I needed an additional warning on top of the warning I already have? If C1:C31 >=100 AND E14=Warning, return Super Warning in another cell. How can I say IF AND when I am relying on the results of another formula (E14)?
      • janetm126's avatar
        janetm126
        Brass Contributor
        Jun 08, 2022
        Tried your formula again and it does work! But it only references one cell being >= 100. How can I make it apply to C5:C35?
  • 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