Hi, I have this nested if formula that works with the exception that it returns "FALSE" in the cell if non of the conditions are met. It will return all the correct responses when error conditions are encountered. I can't see why it doesn't return a blank cell as per the "" at the end of the formula. I suspect it's something really obvious but I think I have now been staring at this formula too long. Any help would be really appreciated - thank you.
=IF(X20="Duplicate","DUPLICATE",IF(AND(J20<>K20,L20<>I20/G20,I20<>J20*G20,J20>=10,I20<>J20+O20,D20<>"Session",T20=S20,Q20="PRIVATE",O20=0),"PRIVATE BILL ERROR",IF(AND(J20<>K20,L20<>I20/G20,I20<>J20*G20,J20>=10,I20<>J20+O20,D20<>"Session",T20=S20,Q20="INTERNAL"),"INTERNAL BILL ERROR",IF(AND(J20<>K20,L20<>I20/G20,I20<>J20*G20,J20>=10,I20<>J20+O20,D20<>"Session",T20=S20,Q20<>"PRIVATE",Q20<>"INTERNAL"),"BILLING ERROR",IF(AND(Q20="PRIVATE",O20<>0),IF(AND(Q20="MyWay",O20<>0),IF(AND(J20<>K20,L20<>I20/G20,I20<>J20*G20,J20>=10,I20<>J20+O20,D20<>"Session",T20=S20,Q20="PRIVATE"),"BILL & TRAVEL ERROR PRIVATE",IF(AND(Q20="PRIVATE",O20<>0),"PRIVATE TRAVEL ERROR",""))))))))
Bookmarks