How can I round a number in Excel to the nearest 5000?
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!
|