I hope you are well and can help. I have an IF Statement
=IF(AND(O4="yes",C4<11,MIN(F4,I4,L4)>=0,MAX(F4,I4,L4)<=1),C4+F4+I4,"Green")
But it does not seem to working correctly. In my picture below you can see that Cell C4 is greater than 11 and the result is still green in Cell R4.
Have I missed something? Any help would be greatly appreciated.
Aucun commentaire:
Enregistrer un commentaire