Rounding whole numbers
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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!
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
20-11-18 08:37 PM
Round([dollarValue]) should do it. There's also RndDn() and RndUp() .
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
21-11-18 01:39 PM
Round to hundreds: Round([DollarValue]/100)*100
