How can I round a number in Excel to the nearest 5000?

T

trainer07

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

Peo Sjoblom

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
 
T

T. Valko

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)
 
B

Bernard Liengme

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
 
T

trainer07

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top