Hello,
I want to be able to do the following:
1. 113,983
2. Round this number up to 114,000 (I know how do this)
=roundup(113983, -3) = 114,000
3. Then I want to reflect 114,000 as 114 (3 digits only)
Can you help me?
Thanks,
Suzanne
Hello,
I want to be able to do the following:
1. 113,983
2. Round this number up to 114,000 (I know how do this)
=roundup(113983, -3) = 114,000
3. Then I want to reflect 114,000 as 114 (3 digits only)
Can you help me?
Thanks,
Suzanne
Last edited by strinchero; 03-08-2011 at 07:19 PM.
Divide by 1000?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks