"if or then" doesn't work 1

[bullkater]

Hi everyone,

problem:
even though the value of one of the two cells is "NA" (and a excel recognizes this) the following dostuff code is executed anyway. Each condition for itself works fine.

If Range("V8").Value <> "NA" Or Range("W8").Value <> "NA" Then

dostuff

End If

Does anyone see my fault?

Thanks in advance.

 

[PHV]

I think you have to replace Or with And[/v]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Bong]

OR should be what you mean.
Are you sure the value of the cell is the string "NA"?
What if you use .text in place of .value?

_________________
Bob Rashkin

 

[Andrzejek]

It may be easier to read this:

If [b]Not[/b](Range("V8").Value = "NA" Or _
       Range("W8").Value = "NA") Then

    dostuff

End If

Have fun.

---- Andy

 

[bullkater]

Thank you all,

Andrzejek's tip is working just fine.

Thanks again!

 

[GlennUK]

I think PHV's makes more sense.

If Range("V8").Value <> "NA" And Range("W8").Value <> "NA" Then

well, that's the way you'd say it in a sentence. ( If I'm not home AND the door is not open, then go away )

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[fumei]

PHV's IS the correct logic for what was asked.

even though the value of one of the two cells is "NA" (and a excel recognizes this) the following dostuff code is executed anyway

My bolding.

OR means if either condition is True then dostuff
AND means both conditions must be True to dostuff.

So, as the OP uses the word "anyway", it can be implied they do not want it to dostuff if one of the cells is "NA". In which case, OR is not correct, and AND is.

However, as the OP is happy with the OR code, I have become confused as to what exactly are the conditions they want to dostuff.

Gerry
My paintings and sculpture

 

[PHV]

Gerry,
Not(X=Y Or Z=T)
is the same as
X<>Y And Z<>T

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[fumei]

Ooops.

Gerry
My paintings and sculpture