Round UP in Excel
Posted by Lisa on January 30, 2002 9:42 AM
Hi. I have this scenerio if anyone can help me. I need a file to ROUND UP all my #'s to the nearest 5,000.
An example of the number would be 43,242.
If I use " =ROUNDUP(B4,-3)" it becomes 44,000.
If I use " =ROUNDUP(B4,-4)" it becomes 50,000.
How can I get it to round up to 45,000?
Thanks, it's probably something simple so please refrain from the dummy jokes. :-)