Thread: Formula error
View Single Post
 
Old 09-06-2022, 08:40 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

In your formulae in column Q there is no 'output' which just says 'CANCELLED', so in no circumstances can you get just 'CANCELLED'.
I've highlighted in red the various 'outputs' in the formula:
=IF(AND(P14<I14,R14>="CANCELLED"),"CANCELLED PARTIAL ISSUE",IF(I14<1," ",IF(P14=0,"OUTSTANDING",IF(P14<I14,"PARTIAL",IF(P14=I14,"COMPLETE","")))))
Reply With Quote