toony
New member
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")))))
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")))))