=+IF(AND(I2="closed",J2="closed"),"Properly Closed / Ready for Acctg",IF(AND(I2="closed",J2="Open"),"Properly Processed / Ready for Johnny",IF(AND(I2="Open",J2="Open"),"Properly Processed / Ready for Johnny",IF(AND(I2="Open",J2="#NA"),"No Reciept",IF(AND(I2="Closed",J2="#NA"),"System Issues",IF(AND(I2="Open",J2="closed"),"System Issues / Ready for Acctg",IF(AND(I2="#NA",J2="#NA"),"No PO / No Reciept",0)))))
when my I2 is OPEN and J2 is #N/A I am getting an #N/A instead of No Receipt. Is there a syntax error or something I'm not seeing?
when my I2 is OPEN and J2 is #N/A I am getting an #N/A instead of No Receipt. Is there a syntax error or something I'm not seeing?