=ROUND(number,-3) will round to the nearest 1000. So 12400 will round to 12000. Then, you can divide 100 to get 120 or divide by 1000 to get 12. Are we getting any closer?
=ROUND(number,-3) will round to the nearest 1000. So 12400 will round to 12000. Then, you can divide 100 to get 120 or divide by 1000 to get 12. Are we getting any closer?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks