View original (French)

How to use "not equal to" in Excel with the "OR" function

Solved
Loic -  
 Loic -
Hello everyone,

I executed this formula: IF(OR(D93<>"France";D93<>"DOM TOM");E93;0), but the cells are all returning the content of cell E93 as a result regardless of the conditions.

I wonder where the error in my formula is?

Thank you

Configuration: Windows / Edge 18.18362i

2 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    try with AND instead of OR
    crdlmnt

    --
    The quality of the response mostly depends on the clarity of the question, thank you!
    0
  2. Loic
     
    I tried with "AND", it works.

    Thank you Vaucluse
    0