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 apply it within the filter condition. I can’t think of a good way to apply your particular example to a filter condition, but sometimes you can get away with it if you think a little backwards. Otherwise figuring it out in the sheet and then only checking for true/false in your filter is easier and a little more flexible by using the IF/THEN column.