Excel IF with Multiple Criteria and Results

[JoeyGaspard]

I have 2 columns in an excel spread sheet, and depending on the contents of the columns, I need to return 1 of 3 results.
If cell A2 is Blank and B2 = XXX, then I need to return Yes
If cell A2 is Blank and B2 is not XXX, then I need to return NO
If cell A2 is NOT blank, then I need to return A2, regardless of what is in B2.
I have tried everything if and ifs statement I know and cant figure this out? Any help is greatly appreciated.

 

[arthurbr]

Perhaps

=IF(A2<>"",A2,IF(AND(A2="",B2="XXX"),"Yes","No"))

 

[JoeyGaspard]

Perhaps

=IF(A2<>"",A2,IF(AND(A2="",B2="XXX"),"Yes","No"))

You are awesome, I cant thank you enough!

 

[arthurbr]

Most welcome