IF AND with 3 outcomes

Hi all, I cant seem to get the flow of this right.

I want my formula to return 3 different outcomes. Yes, No, or X .

IF A1 = "Y" AND B1 is not blank then the result is "Yes"
IF A1 is "Y" BUT B1 is blank then the result is "No"
IF A1 is not "Y" then the answer is "X"

How do you use IF and AND to create that flow of formula, or is there a better way?

Thanks so much

Try this:

=IF(A1<>"Y","x",IF(B1="","No","Yes"))

Hope this helps.

Pete

I think it works, but I've realised that cell B1 actually contains an array formula that is returning a date, this is messing with things because technically, whilst B1 appears blank, it is possibly not. The formula in B1 is {=MAX(IF($V6:$AL6=O$5,$W6:$AM6))}. Not sure how to navigate around that as I think its messing it up.
THANK YOU

=IF(A1<>"Y","x",IF(B1=0,"No","Yes")) perhaps

Brilliant,

I think the final Yes and No were round the wrong way, but this solved it. Thank you