# Formula Help - striking out with If/Then

**URL:** https://community.glideapps.com/t/formula-help-striking-out-with-if-then/53730
**Category:** Ask for Help
**Created:** [November 9, 2022, 5:00pm UTC](https://community.glideapps.com/t/formula-help-striking-out-with-if-then/53730 "2022-11-09T17:00:12Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [November 9, 2022, 5:47pm UTC](https://community.glideapps.com/t/formula-help-striking-out-with-if-then/53730/3 "2022-11-09T17:47:32Z")

</div>

use benchmarks:

> [@Column Type for Range Between 2 Numbers](https://community.glideapps.com/t/column-type-for-range-between-2-numbers/52218):
>
> Hi, I’m trying to figure out which column type to choose for a column that has numbers in it. I have 4 different groups: well below benchmark, below benchmark, at benchmark, and above benchmark. Take a look at this screenshot… [screenshot-docs.google.com-2022.10.21-15\_26\_36] I’m trying to configure the column type to where if a number in a column is in between the range, then it will give me a certain emoji. I tried using if\_then column type, but then realized that it doesn’t really give me th…

[https://sa-test2.glideapp.io/](https://sa-test2.glideapp.io/)

---

_[View the full topic](https://community.glideapps.com/t/formula-help-striking-out-with-if-then/53730)._
