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 réponses

Réponse 1 / 2
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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
Réponse 2 / 2
Loic
 
I tried with "AND", it works.

Thank you Vaucluse
0