Try one of these:

A1 = some number

=ROUND(A1/5000,0)*5000

This one requires the Analysis ToolPak add-in be installed if you're using
versions of Excel prior to Excel 2007:

=MROUND(A1,5000)

--
Biff
Microsoft Excel MVP


"trainer07" wrote in message
...
I would like to round a number in Excel to the nearest 5000. For example,
if
the number is 51285, then I want it to round to 50000. If the number is
53405 then I want it to round to 50000. Any help would be appreciated.
Thank you!