Multiple Nested IF & AND Statments

[XcelNinja]

I need a formula that says:

if D45=E and C45=A, then X
if D45=E and C45=B, then Y
otherwise S

Thoughts?

 

[azumi]

=if(and(c45="a",d45="e"),"x",if(and(c45="b",d45="e"),"y","s"))

 

[jim may]

Try:

=IF(AND(C45="A",D45="E"),"X",IF(AND(C45="B",D45="E"),"Y","Neither A or B are in Cell C45"))

 

[Ron Coderre]

Here's one approach:

=CHOOSE(MAX((D45&C45={"EA","EB"})*{1,2})+1,"S","X","Y")