Hi everyone
I have created a formula as below, unfortunately it doesn't work and I can't find out the problem of it. Please could anyone help to point out the problem?
=IF(R7<>"","Live", IF (X7 = "No","Allocated",IF (N7<>"","Handed", IF(X7="Yes",L7 = "")"Mapped", IF(L7<>""...