

Specialist
2016-01-21
10:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Round to nearest thousand
Hi all,
I'm not able to find a good solution for rounding - floor and ceil would round up or down, but what if I wanted to just round to the nearest thousand? e.g. 500,990 should become 501,000
- Tags:
- rounding
1 Solution
Accepted Solutions

MVP
2016-01-21
10:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 Replies

MVP
2016-01-21
10:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this:
=Round(500990, 1000)


Specialist
2016-01-21
10:21 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Ah, didn't know it was that simple!
4,512 Views

MVP
2016-01-21
10:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
But now you do
