Then as Peo said,

=ROUND(A1/5000,0)*5000

--
__________________________________
HTH

Bob

"trainer07" wrote in message
...
My fault. I meant to say if the number is 53405 round to the nearest 5000
and you would get 55000. If the number is 52400 round to the nearest 5000
and you would get 50000.

"Peo Sjoblom" wrote:

You mean round down, because if you have 53405 and round to the nearest
5000
you would get 55000?

To the nearest 5000

=ROUND(A1/5000,0)*5000

round down to the nearest 5000

=FLOOR(A1,5000)

--


Regards,


Peo Sjoblom

"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!