I have a currency formula field called USD Total where the Amount is multiplied by GBP exchange rate.
USD TOTAL = Amount * 1.22
I'm trying to create a formula where:
- I can add "USD" prefix AND
- The value is round-up to the nearest 10 dollars or nearest 100 dollars
USD 3,475.28 should be displayed as USD 3,500.00
USD 475.28 should be displayed as USD 500.00
I've tried using ROUND and CEILING functions but I'm not getting the result that I want in rounding-up.