Forum Discussion
Rounded currency
Hi!
I have a Currency column and I want to round the value from this column to another one calculated column (RoundedCurrency).
For example $7,812,500 should round to $7,800,000.
Is it possible, using formula?
- NikolinoDEGold Contributor
You can maybe create a calculated column with the following formula:
=CONCATENATE("$", TEXT(ROUND([Currency]/1000000, 0)*1000000, "$###,###,###,##0"))
Replace [Currency] with the internal name of your actual Currency column.
This formula divides the currency value by a million, rounds it to the nearest whole number, and then multiplies it back by a million. The TEXT function is then used to format the number with commas and the "$" symbol.
Please note that the result will be a text string, not a numeric value. If you need to perform further calculations with this rounded value, it might be more appropriate to keep the numeric value in a separate column for calculations and use this formatted text column for display purposes.
The text was created with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
The text was created with the help of AI.