How to remove decimal point when It calcuated by formula

Get Help
3

Hi @Zer151,

As @dilon_perera mentioned and explained for your first case, you need to use formulas for this.

For second case, formulas need to be a bit more tricky. To convert 7520.74 to 7500 or 7585.76 to 7600, try using the following:

ROUND(value / 100) * 100

This is a 2-step logic:

  • “internal” formula rounds up or down your value divided by 100. So for 7520.74 it will be ROUND (7520.74 / 100) = ROUND (75.2074) = 75.
    For 7585.76 it will be ROUND (7585.76 / 100) = ROUND (75.8576) = 76.
    And then on the 2nd step you simply multiply this by 100.

Best,
Victor.

2 Likes