I am using the below formula and i am getting a false result when my criterias fro N14, R14,G14 are all blank. Please help to remove the false value
IF(AND(G14="Legal Consulting ",N14="ADMI"),R14*E14,IF(AND(N14="ADMI",G14<>"Legal Consulting "),"STOP,NOT RECOUPABLE "))
Bookmarks