If function nested with AND

you have
IF(AND(K7="",O7=""),""
and again here
IF(AND(K7="",O7=""),"NoQuote NoPrice"

what are you trying to do here
IF(AND(O7<>"",L7<>"),"PO&Quoted&Priced").
concatenate the Purchase Order and Price
this will just give you the TEXT
"PO&Quoted&Priced"
if you want the cells with the info in - assume PO in A2 and Quoted in B2 and Priced in C2
=A2&B2&C2

You are missing a double quote:

Formula:

=IF(AND(K7="",O7=""),"",

  IF(AND(K7<>"",O7=""),"Needs Pricing",

  IF(AND(K7="",O7<>""),"Needs Quote",

  IF(AND(K7="",O7=""),"NoQuote NoPrice",

  IF(AND(K7<>"",O7<>"",L7<>""),"PO&Quoted&Priced",

  IF(COUNTIF(B7,"*CANCELLED*"),"CANCELLED",

  IF(COUNTIF(B7,"*duplicate*")+COUNTIF(AG7,"*duplicated*"),"DUPLICATE")))))))

Note, the formula will never get as far as this:

Formula:

 IF(AND(K7="",O7=""),"NoQuote NoPrice",

because you start with

Formula:

=IF(AND(K7="",O7=""),"",

Also:

Formula:

=IF(AND(K7="",O7=""),"",

  IF(AND(K7<>"",O7=""),"Needs Pricing",

  IF(AND(K7="",O7<>""),"Needs Quote",

  IF(AND(K7="",O7=""),"NoQuote NoPrice",

  IF(AND(K7<>"",O7<>"",L7<>""),"PO&Quoted&Priced",

  IF(COUNTIF(B7,"*CANCELLED*"),"CANCELLED",

  IF(COUNTIF(B7,"*duplicate*")+COUNTIF(AG7,"*duplicated*"),"DUPLICATE","what goes here?")))))))

Edit - TMS also covered the false as i was typing

Thanks for quick reply. The ampersand is just to indicate that it has a PO and it has been quoted and priced

OK,
BUT you do have the same AND() further in the Nested IF as pointed out by me and TMS , also the missing ""
and a final FALSE condition after the DUPLICATED , so you would get FALSE in the cell if no matches at all

nothing to be embarrassed about, when working coding, often the simple things took longer to find and on a few occasions had to ask only to find i missed a . or ; in a code string
glad its now sorted for you

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.