MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Rounding Numbers to Nearest Number


January 18, 2002 - by Juan Pablo Gonzalez

Kate asks:

Is there anyway in Excel that I can round numbers to the nearest 500 or 1000?

This is one function that I like very much! If the number is in A2 just use this formula:

=CEILING(A2,500)