MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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