Hi
I'm new here so not excatly sure how to structure this but here goes:


I want a formua with the following 4 possible things displayed:
If A1 = X then show 1
If A1 = Z then show 1
If A1 = Y then show 2
If A1 = blank then show blank

So far I have =IF(OR(A1="X",A1="Z"),1,"")
that gives me
If A1 = X then show 1
If A1 = Z then show 1
If A1 = blank then show blank (sort of)

but not If A1 = Y then show 2

Am I coming at this all wrong?
Please help!