IF statements

[David]

I have serached the recent posts and can't find the
solution to this.
If A1 is not blank, return A1 unless the value of A1 is X
or Y in which case return blank. If A1 is blank return
blank. The string I have is =IF(A1=0,"",A1),IF(OR
(A1="X","Y"),"",A1)))
Your help would be appreciated.

 

[RagDyer]

Try this:

=IF(OR(A1={"","X","Y"}),"",A1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

..
I have serached the recent posts and can't find the
solution to this.
If A1 is not blank, return A1 unless the value of A1 is X
or Y in which case return blank. If A1 is blank return
blank. The string I have is =IF(A1=0,"",A1),IF(OR
(A1="X","Y"),"",A1)))
Your help would be appreciated.

 

[Ramakrishnan Rajamani]

Try this

=IF(A1="","",IF(OR(A1="X",A1="Y"),"",A1))

 

[Jonathan Rynd]

Try this:

=IF(OR(A1={"","X","Y"}),"",A1)

Doesn't that have to be entered with control-shift-enter?

 

[hgrove]

Jonathan Rynd wrote...

Doesn't that have to be entered with control-shift-enter?

Test it!

Formulas that should return a *single* that implicitly iterate ove
array *constants* don't have to be array entered. Whenever Excel'
formula parser hits an array constant, it knows that it should b
treated as an array