IF doesn't work with logical or and Strings with wildcards

[matteoluigi]

Actually I try to write an IF query in a worksheet. Sth like:

=IF(((B2<>'')|(B2<>'*A*')|(B2<>'*B*'));'YES';'NO')

 

It's mainly about filtering weather string (it will be a substring later on...) does contain a special word/code or it doesn't. For the beginning I try to filter, wether cell B2 does contain the letter A or B or it doesn't. However B2.1 and B2.2 do contain an '*A*' and '*B*' however the result is still YES.

 

No clue, why... (it will be a main part of my code...)

 

 

 

IF OR.zip

Edited May 19, 2022 by matteoluigi

[Pat Stanford]

Check your logic.  B2<>'' will always be true so it does not matter what the other tests are. Do you really want 

 

((B2<>'') & ((B2<>'*A*') | (B2<>'*B*')))

[matteoluigi]

great, that works!