How do I round a number up to the next 500 or 1,000???


Posted by Kevin Skinner on January 09, 2002 10:09 AM

I need a formula that will round a number up to the next 500 or 1,000. For example, if I have the number 31,150, I need the formula to round the number to 31,500; or if the number was 31,600, I need the formula to round the number to 32,000. I tried using the round function but cannot make it work as I need it to. Is there any way to do this?

Thanks in advance,
Kevin Skinner

Posted by Aladin Akyurek on January 09, 2002 10:12 AM

=CEILING(A1,500) [NT]



Posted by Kevin Skinner on January 09, 2002 10:37 AM

Thanks Aladin