Using "Not" and "And" within if/countif

**aramg83** · 10-27-2010, 10:40 AM

Hi,

I have 4 cells of data, v4, w4, x4, y4. I want to write a formula with the following logic:

If v4=x4 AND (v4 <> w4 OR v4 <> y4), return "tError"
Else return "OK"

What is the correct syntax?

Thanks,

Aram

**Domski** · 10-27-2010, 10:42 AM

=IF(AND(V4=X4,OR(V4<>W4,V4<>Y4)),"tError","OK")

Dom

**daddylonglegs** · 10-27-2010, 11:01 AM

Surely the OR function

=OR(V4<>W4,V4<>Y4)

....is always TRUE.....unless Y4=W4?

Perhaps give some example values of V4, W4 , V4 and Y4 and the results you expect....