# IF THEN ELSE with AND CASE

**URL:** <https://community.glideapps.com/t/if-then-else-with-and-case/11961>\
**Category:** Ask for Help\
**Created:** [July 4, 2020, 2:46pm UTC](https://community.glideapps.com/t/if-then-else-with-and-case/11961 "2020-07-04T14:46:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![qb15](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/qb15/32/9973_2.png) [@qb15](https://community.glideapps.com/u/qb15)\
**Post date:** [July 4, 2020, 2:46pm UTC](https://community.glideapps.com/t/if-then-else-with-and-case/11961/1 "2020-07-04T14:46:10Z")

</div>

Hey guys,

Struggling to combine 2 or more parameters in the IF THEN ELSE. As it doesn’t allow for ifelse or OR, or AND statements.

Is there a workaround for this yet?

Basically I need:  
IF…  
Column A = X  
AND  
Column B = Y  
AND  
Column C = Z  
THEN…  
ELSE IF…

Thanks.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 4, 2020, 2:56pm UTC](https://community.glideapps.com/t/if-then-else-with-and-case/11961/2 "2020-07-04T14:56:28Z")

</div>

Combine the 3 columns using a template column, then make the condition with that template.

---

<div class="post-metadata">

**Author:** ![qb15](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/qb15/32/9973_2.png) [@qb15](https://community.glideapps.com/u/qb15)\
**Post date:** [July 4, 2020, 3:56pm UTC](https://community.glideapps.com/t/if-then-else-with-and-case/11961/3 "2020-07-04T15:56:36Z")

</div>

Awesome. It works. Thanks…

A little messy… but no complaints when things work here 🙂

---

<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:** [July 4, 2020, 8:10pm UTC](https://community.glideapps.com/t/if-then-else-with-and-case/11961/4 "2020-07-04T20:10:44Z")

</div>

You can also create an if/then column in your Data Editor with any of your OR conditions then use the AND conditions in your filter/visibility settings. This is my go to.