Multiple Logic Test syntax

[julhs]

Need some help as my knowledge is limited and I’m struggling with syntax of my formula?

This is what I have so far,

Formula in K18:

=IF(K16=0,"Select nozzle colour",IF(K17=0,"Select # passes",[COLOR="#FF0000"]IF(AND(OR(K16="Red",K16="Blue"),"Select correct nozzle","xxx"),[/COLOR]IF(AND(K16="Red",K17>0),50,IF(AND(K16="Blue",K17>0),37,"CHECK NOZZLE ENTRY")))))

Want the formula in K18 to pick up if an incorrect entry has been made in K16, only correct entries in K16 can be “Red” or “Blue”.
K16 & K17 are input cells.

But as it stands my formula is giving a # value error in K18, but that’s due to the incorrectly constructed part “IF(AND(OR”

I could use a drop down to select only Red & Blue but for now want to do it with formula if possible.

Any help greatly appreciated

 

[Fluff]

How about
=IF(K17<=0,"Select # passes",IF(NOT(OR(K16={"red","Blue"})),"Select nozzle colour",IF(K16="Red",50,37)))

 

[julhs]

Thanks.
Yours is more compact but outcome is the same as this earlier version of mine.

=IF(K16=0,"Select nozzle colour",IF(K17=0,"Select # passes",IF(AND(K16="Red",K17>0),50,IF(AND(K16="Blue",K17>0),37,"Check nozzle entry"))))

Want K18 to initially display "Select nozzle colour", then when “Red” or “Blue” is entered in K16 for K18 to display "Select # passes".
But if anything other than “Red” or “Blue” is entered in K16 then K18 should display "Check nozzle entry" immediately, so BEFORE any entry is made into K17.

But in both yours and my version (added above) "Check nozzle entry" is only displayed in K18 AFTER entries have been made in both K16 & K17

 

[Fluff]

It would have helped if you had said that in your OP!!
I am not a mind reader

 

[Fluff]

Try
=IF(K16="","Select nozzle colour",IF((NOT(OR(K16={"red","Blue"}))),"Check nozzle entry",IF(K17<=0,"Select # passes",IF(K16="Red",50,37))))

 

[julhs]

My apologies for the lack of clarity!!

Thank you for your help, your solution is giving me the outcomes exactly as I wanted.

Many thanks

P.S
Metaphorically speaking you could have written solution on paper and thrown it to me as I’m only on other side of the county

 

[Fluff]

You're welcome & thanks for the feedback.

Unfortunately my paper planes don't even make it to the other side of room, let alone the county