Problem combining not equal to and OR formula

[Keith_Excel]

I'm trying to write a nested IF formula that the first argument looks at a particular cell and is supposed to find any value other than Yes or Discontinued. I've put in my logical test =if(or(A1<>"Yes",A1<>"Discontinued"),True Statement,Further IF Formulas).

On the cells that contain Yes or Discontinued the formula is not returning the false criteria and instead returning the true answer. If I remove the OR statement and just have either the <>"Yes" or <>"Discontinued" the formula works and returns the false answer.

Does anyone know why OR Formula does not work with not equal to conditions?

 

[Comfy]

OR ()

Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.

You want AND()

Returns TRUE if all its arguments evaluate to TRUE; returns FALSE if one or more arguments evaluate to FALSE.

So

With A1 being "Discontinued"
=if(or(A1<>"Yes",A1<>"Discontinued") Will return {TRUE, FALSE} therefore, TRUE