Multiple IF formula

[Apple08]

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<>"", N7=""),"Done",FALSE)) )))

 

[Apple08]

I have now resolved it, thanks.

 

[OGCV1]

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<>"", N7=""),"Done",FALSE)) )))

You can't have IF populate another cell with an answer for example IF(L7 <> "",N7="") will return TRUE or FALSE and will not change the value of N7.
N7 would require an IF formula to make it blank e.g. IF(L7 <> "","",Your Formula).

 

[Apple08]

Thanks!