|
|
#1
09-06-2022, 03:31 AM
|
|||
|
|||
Formula error
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 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Cell formula error?
|
PomDave | Excel | 9 | 10-29-2020 05:43 AM |
| LOOKUP Formula error but WHY??? | Haga | Excel | 1 | 04-17-2019 11:13 PM |
| Array formula value not available error for one result | emarkona | Excel | 1 | 03-08-2018 03:00 PM |
| Error handling in formula - suppress 'Syntax Error' | Cosmo | Word | 7 | 02-24-2014 07:08 AM |
|
formula divide by serio error
|
vthomeschoolmom | Excel | 1 | 04-18-2012 02:29 PM |
Windows 11 
Office 2013
Threaded Mode