vendredi 4 septembre 2015

#Value in If Statment

Can anyone tell me why I am getting #Value error when I change the TRUE and FALSE in to words, once I have put a value into cells A7 and/or B7. What I want to achieve: TRUE=TRUE - working, FALSE= "AWAIT" - not working. I have tested it in a simple if statement at it works fine! Here is the code:

=IF(IF(C7=1,"TRUE","FALSE"), IF(ISBLANK(D7),"DISPATCH", IF(ISBLANK(C7), "SHIPPED", "SHIPPED")))

Thanks in advance.

Aucun commentaire:

Enregistrer un commentaire