|You need a Nested IF with an OR. |
However, you seem to be missing a condition. What do you want returned if A1 does not equal any of your 4 choices? e.g. What happens if A1 contains Q?
This formula will get you what you asked for. It will return "" when A1 is blank, but it will also return "" for anything other than X, Y or Z.
Will that work for you?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.