Forum Discussion

MDawson2025's avatar
MDawson2025
Copper Contributor
Sep 18, 2023
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 stopped working as have any formulas based on this cell.

 

I have formatted the cell as number but to no avail. As you can see below, the previous 3 columns produce the %s I need, but the final column does not.

 

This is my IF statement from the O5 cell. The error message is linked to it being a locked cell. I have locked and unlocked to no avail. Apologies if I haven't given enough information. Please ask for more if needed. First time post. 

 

 

  • MDawson2025 

    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.

     

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    MDawson2025 

    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.

     

Resources