Combining 3 IF/AND statements with OR

[lsargent]

I need to combine the following statements and am getting stuck:

IF W36="Constant Value"

AND...

W38="Value1" OR...
W38="Value2" OR...
W38="Value3"

Enter "X", Else "Y"

Thanks in advance!

[jeffreybrown]

Try

=IF(AND(OR(W38={1,2,3}),W36=32),"X","Y")

Note: I replaced your "values" with real values because I assumed they are numbers.

[lsargent]

Perfect, thanks!