# How to set range between two numbers

**URL:** <https://community.glideapps.com/t/how-to-set-range-between-two-numbers/42344>\
**Category:** Ask for Help\
**Created:** [May 24, 2022, 8:21pm UTC](https://community.glideapps.com/t/how-to-set-range-between-two-numbers/42344 "2022-05-24T20:21:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ohad](https://avatars.discourse-cdn.com/v4/letter/o/f04885/32.png) [@ohad](https://community.glideapps.com/u/ohad)\
**Post date:** [May 24, 2022, 8:21pm UTC](https://community.glideapps.com/t/how-to-set-range-between-two-numbers/42344/1 "2022-05-24T20:21:44Z")

</div>

Hi,  
How do you set range between numbers for one input cell?  
I’ll explain,  
My users has to answer questions by inserting numbers.  
For example, how many cups of water did you drink today?  
Right answer is 5 to 8 = OK.  
Wrong is less then 5 or greater then 8 = NOT OK.  
IF: the answer is OK, then show “…”  
IF: the answer is NOT ok, then show something else.

How is that achievable?  
Thank you.

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [May 24, 2022, 8:45pm UTC](https://community.glideapps.com/t/how-to-set-range-between-two-numbers/42344/2 "2022-05-24T20:45:28Z")

</div>

Welcome to your home @ohad !

you need something like this

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/a/8a6459f4d1920f607541ccc0f990f9a8648eb5f6.png)

Saludos!

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 24, 2022, 8:46pm UTC](https://community.glideapps.com/t/how-to-set-range-between-two-numbers/42344/3 "2022-05-24T20:46:52Z")

</div>

This…👆

Use an if then else column…

If the numbers are always going to be 5 and 8 as the limits, you can just enter those values directly into the If Then Else column.

If # is greater than 8, then NOT OK, if # is less than 5 then NOT OK, else OK.
