Hi. I have the below formula but it returns FALSE if it it's false.
Can anybody advise how to read of it please?
=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")))))
Bookmarks