# If then else column return value

**URL:** <https://community.glideapps.com/t/if-then-else-column-return-value/27944>\
**Category:** Ask for Help\
**Created:** [June 12, 2021, 10:37pm UTC](https://community.glideapps.com/t/if-then-else-column-return-value/27944 "2021-06-12T22:37:40Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![rayo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rayo/32/91372_2.png) [@rayo](https://community.glideapps.com/u/rayo)\
**Post date:** [June 12, 2021, 10:37pm UTC](https://community.glideapps.com/t/if-then-else-column-return-value/27944/1 "2021-06-12T22:37:40Z")

</div>

I have a **lookup** column that returns the **shipping method price** from a relation with the shipping table depending on the shipping options / method you select.  
the column values appear with currency and decimals ex. $0.00, $5.00, $10.00

I have another If-Then-Else column for **Shipping Price** that checks if the order is a pickup or a delivery.  
If pickup then it sets value of shipping to $0.00  
and if delivery it sets the value to the lookup column **shipping method price** BUT THE PROBLEM is the $ sign and currency format is lost.  
Why does the If-then-else column return a different format than the lookupcolumn? How can i change it back to decimal with $ sign showing? any advice on what is happening in the background?

---

<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:** [June 12, 2021, 10:42pm UTC](https://community.glideapps.com/t/if-then-else-column-return-value/27944/2 "2021-06-12T22:42:16Z")

</div>

This might be happening because not all rows are $ or some are empty… Add a math column to multiple by $1

---

<div class="post-metadata">

**Author:** ![rayo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rayo/32/91372_2.png) [@rayo](https://community.glideapps.com/u/rayo)\
**Post date:** [June 12, 2021, 10:59pm UTC](https://community.glideapps.com/t/if-then-else-column-return-value/27944/3 "2021-06-12T22:59:58Z")

</div>

its weird because all rows have values .

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/2/22040433263d613f37c172b178c8d2e5d9291918.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/d/1db85eb28b5145696e78fb862307d436e8c7103f.png)

I was hoping to solve it without adding more columns to my already long list of columns, but yes multiplying by 1.00 $ solved the issue.  
Thank you very much

---

<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:** [June 12, 2021, 11:11pm UTC](https://community.glideapps.com/t/if-then-else-column-return-value/27944/4 "2021-06-12T23:11:47Z")

</div>

Try to change else value from $0.00 to just 0, because $0.00 in this case might be read as a text.

---

<div class="post-metadata">

**Author:** ![rayo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rayo/32/91372_2.png) [@rayo](https://community.glideapps.com/u/rayo)\
**Post date:** [June 13, 2021, 4:57am UTC](https://community.glideapps.com/t/if-then-else-column-return-value/27944/5 "2021-06-13T04:57:29Z")

</div>

i tried that but didin’t work… will go with your solution of multiplying by 1.00$ i guess

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/if-then-else-column-return-value/27944/6 "2024-01-17T16:51:50Z")

</div>