Assuming a typo and you want 53405 - 55000 then use one of
=MROUND(A1,5000)
=ROUND(A1/5000,0)*5000
The first requires you have ToolPak loaded unless you are in XL2007
If there is no typo then try =INT(A3/5000)*5000
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"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!