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. :-)
Lisa
Posted by Dan Aragon on January 30, 2002 9:50 AM
=Roundup(B4/5000,0)*5000
Posted by Steve Hartman on January 30, 2002 9:57 AM
=(ceilingB4,5000)
Posted by Steve Hartman on January 30, 2002 10:01 AM
THAT SHOULD BE!! =CEILING(B4,5000)
Posted by Lisa on January 30, 2002 10:18 AM
Re: =Roundup(B4/5000,0)*5000
Thanks to both of you! Appreciate your help.
Lisa
Posted by Dan Aragon on January 30, 2002 10:23 AM
Cool, never used that function before....
Posted by Lisa on January 30, 2002 10:29 AM
Re: THAT SHOULD BE!! =CEILING(B4,5000)
Thanks, Steve.....I just may have to come back here again!
Lisa
