Formula Help: Possible Nested IF/AND issue

[schmitkl]

I'm having trouble coming up with a formula that will check for certain conditioners in a specific order. Any help is appreciated.

If D144 is blank and E144 is not ‘Specific Text A or Specific Text B’, return E144. If D144 is Blank and E144 contains ‘Specific Text A’ return ‘Specific Text X’. If D144 is Blank and E144 contains ‘Specific Text B’ return ‘Specific Text Y’. If D144 is not blank, return D144.

I hope that makes sense. Thank you to the community in advance!
-Karen

 

[Scott Huish]

=IF(D144<>"",D144,IF(AND(E144<>{"Specific Text A","Specific Text B"}),E144,IF(E144="Specific Text A","Specific Text X",IF(E144="Specific Text B","Specific Text Y",""))))

 

[schmitkl]

Thank you!!!!!!!!!!!@