# IF THEN ELSE multiple condition

**URL:** <https://community.glideapps.com/t/if-then-else-multiple-condition/22222>\
**Category:** Ask for Help\
**Created:** [February 4, 2021, 3:07am UTC](https://community.glideapps.com/t/if-then-else-multiple-condition/22222 "2021-02-04T03:07:59Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Craig\_Greiner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/craig_greiner/32/12306_2.png) [@Craig\_Greiner](https://community.glideapps.com/u/Craig_Greiner)\
**Post date:** [February 4, 2021, 3:07am UTC](https://community.glideapps.com/t/if-then-else-multiple-condition/22222/1 "2021-02-04T03:07:59Z")

</div>

I have a complex IF THEN ELSE that can easily be done in sheets by I am trying to move to GLIDE data engine:

IF AND(A\<B,C\<D) THEN Option1  
ELSEIF E=F THEN Option2  
ELSE Option3  
END

I believe the ELSE IF is taken care of by adding a second case, but is there a way to do the AND statement? I imagine I could set up a second calculate to determine if the AND is TRUE, but is there a cleaner way?

---

<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:** [February 4, 2021, 4:35am UTC](https://community.glideapps.com/t/if-then-else-multiple-condition/22222/2 "2021-02-04T04:35:21Z")

</div>

Would the AND condition ever happen at the same time that E=F? Could they both be true? If not, I would structure it this way:

If E=F Then Option2  
ElseIf A\>B Then Option3  
Elseif C\>D Then Option3  
Else Option1

---

<div class="post-metadata">

**Author:** ![Craig\_Greiner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/craig_greiner/32/12306_2.png) [@Craig\_Greiner](https://community.glideapps.com/u/Craig_Greiner)\
**Post date:** [February 4, 2021, 4:40am UTC](https://community.glideapps.com/t/if-then-else-multiple-condition/22222/3 "2021-02-04T04:40:46Z")

</div>

Yes they could occur at the same time. I am relying on the statement order to then set priority.

---

<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:** [February 4, 2021, 4:49am UTC](https://community.glideapps.com/t/if-then-else-multiple-condition/22222/4 "2021-02-04T04:49:44Z")

</div>

In that case, you may have to break it up into two If/Then columns. First to check ABCD, as I’m showing above, and return true or false. Then a second If/Then column to check if the first If/Then is true, then Option1…ElseIF Option2…Else Option3.