Thread: Formula error
View Single Post
 
Old 09-12-2022, 02:05 AM
Marcia's Avatar
Marcia Marcia is offline Windows 11 Office 2021
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 551
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
How about this:
=IF(AND(P2=0,R2>="CANCELLED"),"CANCELLED",IF(I2<1, " ",IF(P2=0,"OUTSTANDING",IF(AND(P2<I2,R2>="CANCELLE D"),"PARTIAL ISS REMAINING QTY CNX",IF(P2=I2,"COMPLETE","PARTIAL")))))
Reply With Quote