# How to change this price column

**URL:** <https://community.glideapps.com/t/how-to-change-this-price-column/36570>\
**Category:** Ask for Help\
**Created:** [January 1, 2022, 6:50pm UTC](https://community.glideapps.com/t/how-to-change-this-price-column/36570 "2022-01-01T18:50:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [January 1, 2022, 6:50pm UTC](https://community.glideapps.com/t/how-to-change-this-price-column/36570/1 "2022-01-01T18:50:54Z")

</div>

Hi

I have a tag msg as sale,the product under sale are to be priced -10 rs.

Means,

Price is 50 it should show 40.only products with tag msg as sale.

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [January 1, 2022, 6:59pm UTC](https://community.glideapps.com/t/how-to-change-this-price-column/36570/2 "2022-01-01T18:59:44Z")

</div>

1. Create a math column that subtracts the discount from the price. ([PRICE]-10)
2. Create and if then else column that results in either a discounted price or the actual price based on the condition of whether or not it’s on sale.
3. Use the if then else column for display and calculation purposes