# Is this a bug?

**URL:** <https://community.glideapps.com/t/is-this-a-bug/84646>\
**Category:** Ask for Help\
**Created:** [September 28, 2025, 11:38pm UTC](https://community.glideapps.com/t/is-this-a-bug/84646 "2025-09-28T23:38:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\
**Post date:** [September 28, 2025, 11:38pm UTC](https://community.glideapps.com/t/is-this-a-bug/84646/1 "2025-09-28T23:38:21Z")

</div>

Hi all

So I’m wondering if the below is a bug? I would have thought the IF THEN column would have shown exactly what was in either of the two preceding columns but it is stripping out the $ sign and the period and cents value?? Is there a way to stop it doing this?

Thanks

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/512a62592d4ed0c5d39013231f996e47e232a5f9.png)

---

<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:** [September 29, 2025, 12:51am UTC](https://community.glideapps.com/t/is-this-a-bug/84646/2 "2025-09-29T00:51:36Z")

</div>

The IF column always uses the underlying value without any formatting or precision applied. Your best bet is to use a math column to apply formatting to the IF column result.

---

<div class="post-metadata">

**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\
**Post date:** [September 29, 2025, 1:14am UTC](https://community.glideapps.com/t/is-this-a-bug/84646/3 "2025-09-29T01:14:16Z")

</div>

Ahhh, that’s the trick! Thanks!

---

<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:** [October 6, 2025, 1:14am UTC](https://community.glideapps.com/t/is-this-a-bug/84646/4 "2025-10-06T01:14:25Z")

</div>

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