# Filtering ranges

**URL:** <https://community.glideapps.com/t/filtering-ranges/66611>\
**Category:** Ask for Help\
**Created:** [September 29, 2023, 3:39am UTC](https://community.glideapps.com/t/filtering-ranges/66611 "2023-09-29T03:39:54Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 1, 2023, 3:41am UTC](https://community.glideapps.com/t/filtering-ranges/66611/5 "2023-10-01T03:41:20Z")

</div>

> [@nathanaelb](#):
>
> - If price \< 50, then “Below $50”
> - If price ≥51 and \<100, then “Between $50 and $100”
> - Else “Above $100”

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

> [@ThinhDinh](#):
>
> - If price \> 100, then “Above $100”
> - If price ≥ 51, then “Between $50 and $100”
> - Else, then “Below $50”.

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”

 ![CleanShot 2023-10-01 at 11.38.48@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/d/dd26f88a996132d436c0c7ae70ce5624f426a53b.jpeg)

---

_[View the full topic](https://community.glideapps.com/t/filtering-ranges/66611)._