Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Rounding whole numbers

WendyJohnson
Level 3

‎20-11-18 08:02 PM

How would I accomplish this calculation for rounding? $1234.00.  would round down to $1200.  or $1257 would round up to $1300 Thanks!
0 Likes
2 REPLIES 2

AmiBarrett
Level 12

‎20-11-18 08:37 PM

Round([dollarValue]) should do it. There's also RndDn() and RndUp() . 
0 Likes

AndreyKudinov
Level 10

‎21-11-18 01:39 PM

Round to hundreds: Round([DollarValue]/100)*100
0 Likes