# In Between Two Values
**URL:** https://community.glideapps.com/t/in-between-two-values/67524
**Category:** Ask for Help
**Created:** [November 4, 2023, 3:44am UTC](https://community.glideapps.com/t/in-between-two-values/67524 "2023-11-04T03:44:17Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@nkatglide](https://community.glideapps.com/u/nkatglide)
#### Post date: [November 4, 2023, 3:44am UTC](https://community.glideapps.com/t/in-between-two-values/67524/1 "2023-11-04T03:44:17Z")
Hello,
I am trying to figure out if there is a way to check if a number is between two other numbers.
In the screenshot above, as an example, I would like to check if a value is between 80 and 89, in the math rollup, and then print something out if the statement
is true.
Thank you
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [November 4, 2023, 6:17am UTC](https://community.glideapps.com/t/in-between-two-values/67524/2 "2023-11-04T06:17:14Z")
Use an if-then-else column:
- If Number is greater than 89, then “not something”
- If Number is less than 80, then “not something”
- Else “something”
---
### Author:  [@nkatglide](https://community.glideapps.com/u/nkatglide)
#### Post date: [November 4, 2023, 10:55pm UTC](https://community.glideapps.com/t/in-between-two-values/67524/3 "2023-11-04T22:55:49Z")
Hello,
I did try using the if-else-statments, however I am trying to organize them by the values. What that means is that all the 80-89 get one value while the 70-79 get another etc. The problem with the else is that is will associate all with that value.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [November 4, 2023, 10:59pm UTC](https://community.glideapps.com/t/in-between-two-values/67524/4 "2023-11-04T22:59:55Z")
That should be pretty easy to do with an IF column.
You would set up your IF column something like this.
```auto
IF number > 89 then X
ELSEIF number > 79 then Y
...
...
ELSE Z
```
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [November 5, 2023, 1:29am UTC](https://community.glideapps.com/t/in-between-two-values/67524/5 "2023-11-05T01:29:59Z")
> [@nkatglide](#):
>
> I did try using the if-else-statments, however I am trying to organize them by the values. What that means is that all the 80-89 get one value while the 70-79 get another etc.
Well, you didn’t say that earlier, did you?
As Jeff pointed out, you could still use an if-then-else column.
Another option would be a Query column. Take a look at the below video beginning at 4:40.
[ ](https://www.youtube.com/watch?v=2K3KzgbrXT8&t=280)