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 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.
1 Like