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