How to avoid the FALSE result in a formula

toony

New member
Joined
Mar 6, 2014
Messages
49
Reaction score
0
Points
0
Location
UK
Excel Version(s)
Excel 2016
Hi I have the formula below but it returns FALSE when I want it empty if C8 cell is empty.
Can you help pls?

=IF(C8="","",IF(AND(K8<>"",O8=""),"Needs Pricing",IF(AND(K8="",O8<>""),"Needs Quote",IF(AND(K8="",O8=""),"NoQuote NoPrice",IF(AND(K8<>"",O8<>""),"Quoted&Priced")))))
 
Back
Top