problem creating string using <> to exclude

[Julz]

good afternoon

have been using
=IF(OR(Z1=29302,Z1=28751),U1,"") to include cells w/ 29302 or 28751

thought this would work to exclude the same, but it's still including
them.
=IF(OR(Z1<>29302,Z1<>28751),U1,"")

please advise.

thanx,
~julz

 

[PegL]

use AND instead of OR for negatives.

 

[Julz]

I wrote too soon. I figured out what I was doing wrong.
=IF(OR(Z1<>29302)+(Z1<>28751),U1,"")
did the trick!

 

[Niek Otten]

Don't know what your question is, really.

Anyway,

"=IF(OR(Z1<>29302,Z1<>28751),U1,"")"

Z1 will always be not equal to at least one of them, so the answer will
always be TRUE

Post again with an explanation of what you're trying to achieve

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[AlfD]

Hi!

You could try AND instead of OR. You want both of the two values to b
excluded so neither condition must be true.

Al

 

[AlfD]

Hi!

You could try AND instead of OR.

Al

 

[Aladin Akyurek]

=IF(ISNA(MATCH(Z1,{29302,28751},0)),U1,"")

What are these numbers -- dates?