# Combining Cases in If-Then-Else column

**URL:** <https://community.glideapps.com/t/combining-cases-in-if-then-else-column/85904>\
**Category:** Ask for Help\
**Created:** [January 6, 2026, 2:48pm UTC](https://community.glideapps.com/t/combining-cases-in-if-then-else-column/85904 "2026-01-06T14:48:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Paarl\_Bus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paarl_bus/32/84589_2.png) [@Paarl\_Bus](https://community.glideapps.com/u/Paarl_Bus)\
**Post date:** [January 6, 2026, 2:48pm UTC](https://community.glideapps.com/t/combining-cases-in-if-then-else-column/85904/1 "2026-01-06T14:48:47Z")

</div>

Good day. I have changed the tariff structure for my customers and it now has options for full-time, semi-full time and part-time passengers. Full-time passengers reserve a seat for every trip, semi’s for half of the trip and part-time not at all (like standby). I addition, if a customer has more than 1 child on the bus, the extra kids get a 20% discount each.

I want to calculate the tariff for each child in a column in the Children table but the order of the cases has me stymied. There has to be cases for:

1. 1st child, full-time or semi-full time (tariff code \<50, SibSeq=1,uses FullTariff column value)
2. Additional child, full-time or semi-full time (tariff code \<50, SibSeq\>1,uses Discount column value)
3. Any standby child (tariff code \>50, uses FullTariff column value)

I can get the standby tariff and either the 1st child or additonal child correct, but the other child’s tariff is blank. I have read the docs but it really is not worth the screen estate it occupies. I saw a post long ago about combining AND and OR (basically put the negative answers first, or something like that - can’t find it now), but the logic flow still escapes me.

Here is a screenshot:

 ![Tariff calc cases](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c92e888b9bd3ceea94accf3d48383936325f5fbe.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 6, 2026, 2:57pm UTC](https://community.glideapps.com/t/combining-cases-in-if-then-else-column/85904/2 "2026-01-06T14:57:00Z")

</div>

> [@Paarl\_Bus](#):
>
> - 1st child, full-time or semi-full time (tariff code \<50, SibSeq=1,uses FullTariff column value)
> - Additional child, full-time or semi-full time (tariff code \<50, SibSeq\>1,uses Discount column value)
> - Any standby child (tariff code \>50, uses FullTariff column value)

The trick here is to reverse your logic, and use a process of elimination. Try the following:

- If Tariff Code \> 50, then FullTariff
- If SibSeq \> 1, then Discount
- If SibSeq = 1, then FullTariff

Question: What should happen if SibSeq is less than 1? (or is that not possible?)

---

<div class="post-metadata">

**Author:** ![Paarl\_Bus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paarl_bus/32/84589_2.png) [@Paarl\_Bus](https://community.glideapps.com/u/Paarl_Bus)\
**Post date:** [January 6, 2026, 3:13pm UTC](https://community.glideapps.com/t/combining-cases-in-if-then-else-column/85904/3 "2026-01-06T15:13:04Z")

</div>

Thank you so much Darren ,I will try it soon - not home at the moment.  
Since the SibSeq is the actual order in which siblings are added, a negative number is not possible. Should the eldest one finish school, they just get a new Status # which is ignored when calculating SibSeq.

---

<div class="post-metadata">

**Author:** ![Paarl\_Bus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paarl_bus/32/84589_2.png) [@Paarl\_Bus](https://community.glideapps.com/u/Paarl_Bus)\
**Post date:** [January 6, 2026, 4:57pm UTC](https://community.glideapps.com/t/combining-cases-in-if-then-else-column/85904/4 "2026-01-06T16:57:17Z")

</div>

Worked a dream! Thanks @Darren_Murphy .

---

<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:** [January 13, 2026, 4:57pm UTC](https://community.glideapps.com/t/combining-cases-in-if-then-else-column/85904/5 "2026-01-13T16:57:27Z")

</div>

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