mardi 2 février 2016

AND+OR function not working as supposed to

Hello again kind people of the StackOverflow community.

I've got the following formula

 =IF((AND(OR(AND($D5<-9;$F5>=150;$H5>=150);AND($D5<-6;$F5>=185;$F5>190))
  ;NOT(EXACT(I5;"MEAC"));NOT(EXACT(I5;"AE"));NOT(EXACT(I5;"Asun"));
   NOT(EXACT(I5;"BSth"));NOT(EXACT(I5;"SWAC"));NOT(EXACT(I5;"Pat"));NOT(EXACT(I5;"NEC"))
  ;NOT(EXACT(I5;"Slnd"));NOT(EXACT(I5;"C-USA"))));B5&" +"&ABS(D5);" ")

What I want it to do is IF $D5<-9;$F5>=150;$H5>=150 OR $D5<-6;$F5>=185;$F5>190 AND if one of the above is True, filter for the NOT(EXACT strings

Should I use AND(AND(AND instead of AND(OR(AND ? I know the formula looks messy but I'm not an excel wizard.

Aucun commentaire:

Enregistrer un commentaire