# If/Then and Math

**URL:** <https://community.glideapps.com/t/if-then-and-math/43231>\
**Category:** Ask for Help\
**Created:** [June 18, 2022, 2:02pm UTC](https://community.glideapps.com/t/if-then-and-math/43231 "2022-06-18T14:02:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rleinen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rleinen/32/43270_2.png) [@rleinen](https://community.glideapps.com/u/rleinen)\
**Post date:** [June 18, 2022, 2:02pm UTC](https://community.glideapps.com/t/if-then-and-math/43231/1 "2022-06-18T14:02:19Z")

</div>

I’m trying to create columnA (If/Then column) that will display a formatted number value based on a condition. The condition looks at the value in columnB (a Math column). If columnB contains a value then it returns that value in columnA. If it has no value, then columnA receives the value from columnC (another Math column). My If/Then works but it loses the number formatting. Is there a way to do this without losing the formatting?

---

<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:** [June 18, 2022, 2:13pm UTC](https://community.glideapps.com/t/if-then-and-math/43231/2 "2022-06-18T14:13:45Z")

</div>

This is a known issue. The workaround is to add another math column at the end to re-apply the desired formatting.

---

<div class="post-metadata">

**Author:** ![rleinen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rleinen/32/43270_2.png) [@rleinen](https://community.glideapps.com/u/rleinen)\
**Post date:** [June 18, 2022, 2:16pm UTC](https://community.glideapps.com/t/if-then-and-math/43231/3 "2022-06-18T14:16:07Z")

</div>

Brilliant! Thank you!