---
title: "Rate card FAQ: how to use a Between filter for a range of values"
description: "Using a Between filter (end exclusive / end inclusive) in a rate table affects how ranges are applied."
url: https://help.qargo.com/us/articles/275699-rate-card-faq-how-to-use-a-between-filter-for-a-range-of-values
locale: us
updated: 2025-02-25
---

# Rate card FAQ: how to use a Between filter for a range of values

_Q: A rate table was created using a range of values (or tiers), and it does not rate as expected. The ranges are off or missing altogether. Why?_

_A: Check how the rate table **'Between'** filters have been set up in the table._

When a range of values is used to build a rate table, there are 2 **'Between'** filter options to choose from. Ranges can represent anything from a ZIP code to a quantity or distance value. When available, the 2 filter options show as **'Between (end _exclusive_)'** and **'Between (end _inclusive_)'**.

![](https://help.qargo.com/media/a4eb8f81e0da-image.png)

-   End **_exclusive_**: This **_excludes_** the end value entered in the range

    -   Example

        -   0–700 = 0–699
        -   701–1400 = 700–1399
-   End **_inclusive_**: This **_includes_** the end value entered in the range

    -   Example

        -   0–700 = 0–700
        -   701–1400 = 700–1400

* * *

_Q: How are the **'Between'** filters used if the values include decimal points?_

_A: To avoid decimal gaps, determine which tier the value should fall into and use the appropriate **'Between'** filter to accommodate it._

Example:

-   If 700 needs to fall into the _first tier_:\
    **End inclusive**\
    **0–700**\
    700–1400

-   If 700 needs to fall into the _second tier_:\
    **End exclusive**\
    0–700\
    **700–1400**


## Related articles

- [Rate card FAQ – Pallet network: multi-tier rating](https://help.qargo.com/us/articles/249378-rate-card-faq-pallet-network-multi-tier-rating.md)
- [Rate card FAQ – Fixed price route (pickup and delivery)](https://help.qargo.com/us/articles/249376-rate-card-faq-fixed-price-route-pickup-and-delivery.md)
- [Rate card FAQ – Price list per distance – 2 calculations with conditions](https://help.qargo.com/us/articles/250622-rate-card-faq-price-list-per-distance-2-calculations-with-conditions.md)
- [Rate card FAQ – pallet network: delivery location and pallet spaces](https://help.qargo.com/us/articles/250623-rate-card-faq-pallet-network-delivery-location-and-pallet-spaces.md)
- [ZIP code zone groups](https://help.qargo.com/us/articles/133809-zip-code-zone-groups.md)
