This is my formula. Everything works except I cannot differentiate between Cancelled and Partial Cancelled.

=IF(AND(P2<I2,R2>="CANCELLED"),"CANCELLED PARTIAL SSUE",IF(I2<1,"",IF(P2=0,"OUTSTANDING",IF(P2<I2,"P ARTIAL",IF(P2=I2,"COMPLETE","")))))

COLUMNS
I P Q R
Qty QTY STATUS REMARKS
RCVD
10 10 COMPLETE
10 5 PARTIAL
1 1 COMPLETE
1 OUTSTANDING


10 5 CANCELLED PARTIAL ISSUE CANCELLED AS PER MC
5 CANCELLED PARTIAL ISSUE CANCELLED AS PER SO1 THIS SHOULD READ CANCELLED because P is blank yet it is showing Cancelled Partial Issue