Formula Error
I added the additional information.
=IF(AND(P2=0,R2>="CANCELLED"),"CANCELLED",IF(I2<1, " ",IF(P2=0,"OUTSTANDING",IF(P2<I2,"PARTIAL",IF(P2=I 2,"COMPLETE",IF(AND(P16<I16,R15>="CANCELLED"),"PAR TIAL ISS REMAINING QTY CNX",))))))
I get the cancelled notification but now I cannot get the "PARTIAL ISS REMAINING QTY CNX" comment. The column reverts back to PARTIAL.
Maybe my Snytax is off. As I stated before, I would like to have any Document Number that is cancelled but received a partial issus to read "PARTIAL ISS REMAINING QTY CNX"
|