Filter combination of ands/ors

[Jeff_Hager]

See if this gives you some ideas:

Logical Math Column

No, you currently cannot mix AND’s and OR’s in conditions, but there are a few options: Put all of the logic in your sheet using however many columns are necessary, or reverse your thought a little bit and set up an IF/THEN column like this: IF C=0 THEN ‘true’ ELSE IF A<>1 THEN ‘false’ ELSE IF B<>1 THEN ‘false’ ELSE ‘true’ Put all of the AND logic in the sheet and only use OR’s withing the filter conditions. Not always, but sometimes you can reverse your thinking like the first example and…