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