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

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!

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

To round a number in Excel to the nearest 5000:

1. Type the number you want to round in a cell. For example, let's say you want to round the number 51285 in cell A1.
2. In another cell, type the number 5000. For example, you can type 5000 in cell B1.
3. In a third cell, use the following formula:
   Code:

   ---

   =ROUND(A1/B1,0)*B1

   ---

   . For example, you can type this formula in cell C1.
4. Press Enter to calculate the formula. The result will be the rounded number to the nearest 5000.

So, in our example, if you type 51285 in cell A1, type 5000 in cell B1, and type the formula in cell C1, you will get the result 50000 in cell C1.

Similarly, if you want to round the number 53405 to the nearest 5000, you can follow the same steps and you will get the result 55000.

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

=ROUND(A20/50000,0)*50000

--
__________________________________
HTH

Bob

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

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!

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

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!

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

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!

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

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!

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

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!