Forum Discussion
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 all I can do to figure it out. Would someone please tell me how to write this dang formula? Thank you!
- 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)?
- >3! Thank you! I could not figure out how to add that in! I appreciate you so much.
