Daily tips for using Microsoft Excel.

Friday, January 18, 2002

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)