Filtering ranges

You wouldn’t actually be able to configure the second case, because each case can only have one condition :wink:
Also, a price of $100 would return “Above $100”
And any price between $50.00 and $50.99 would also return “Above $100”

Not quite strictly correct, because a price of $50 would return “Below $50”

I’d do it like this:

  • If price is greater than 100, then “Above $100”
  • If price is equal to or greater than 50, then “Between $50 and $100”
  • Else “Below $50”

3 Likes