# Alternative to multiple if then else

**URL:** <https://community.glideapps.com/t/alternative-to-multiple-if-then-else/78194>\
**Category:** Ask for Help\
**Created:** [November 26, 2024, 2:39am UTC](https://community.glideapps.com/t/alternative-to-multiple-if-then-else/78194 "2024-11-26T02:39:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lachlan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lachlan/32/79092_2.png) [@Lachlan](https://community.glideapps.com/u/Lachlan)\
**Post date:** [November 26, 2024, 2:39am UTC](https://community.glideapps.com/t/alternative-to-multiple-if-then-else/78194/1 "2024-11-26T02:39:17Z")

</div>

struggling to find a simple solution to this problem…  
i need to have the user input various data (i have this under control). Each input needs to return a value depending on where it sits in a corresponding list.

ie as per this screen shot, if the user inputs a listing price of $550,000 it should return 0%, or if they input client difficulty as Difficult, it should return 15%.

 ![Capture2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/5/85d9db1e8cb1185a0129c907944d1d65bee6bd87.png)

Can make this work based on very lengthy if then else columns but id like to keep this variable if possible as the ranges in the lookup lists may change.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 26, 2024, 3:44am UTC](https://community.glideapps.com/t/alternative-to-multiple-if-then-else/78194/2 "2024-11-26T03:44:30Z")

</div>

If you have the table from your screenshot included as a table in your app, you can use a Query column and Single Value column to get corresponding impact values in cases where you might be dealing with ranges of values. For everything else, you can use a Relation column and Lookup column to get the impact value from matching values.

---

<div class="post-metadata">

**Author:** ![Lachlan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lachlan/32/79092_2.png) [@Lachlan](https://community.glideapps.com/u/Lachlan)\
**Post date:** [November 26, 2024, 4:57am UTC](https://community.glideapps.com/t/alternative-to-multiple-if-then-else/78194/3 "2024-11-26T04:57:42Z")

</div>

Thanks Jeff - Query column and Single Value has done the trick. Had to filter the Query to be \> actual listing price. Feels like i tried all but this scenario before reaching out for support.

Once again, appreciate the help!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [December 3, 2024, 4:58am UTC](https://community.glideapps.com/t/alternative-to-multiple-if-then-else/78194/4 "2024-12-03T04:58:33Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.