Forum Discussion
Solved
IF statement, conditional formatting
Good afternoon, I have written a basic IF AND statement =IF(AND(L5>1,M5>1,N5>1),"2","1") and even though this is producing what I would like it to, the conditional formatting element has...
I guess you need to return numbers, not texts
=IF(AND(L5>1,M5>1,N5>1),2,1)If you apply Number format to text it doesn't convert it number, still will be text.
I guess you need to return numbers, not texts
=IF(AND(L5>1,M5>1,N5>1),2,1)If you apply Number format to text it doesn't convert it number, still will be text.
- Thank you. I feel daft now but I appreciate the quick response.
MDawson2025 , you are welcome
