Round to the Neares 100
 

I am working on employee proposed salaries and need to round to the nearest
50 or 100, such as below. Please help.
Thank you.

55,769 = 55,800
60, 112 = 60,100
52,562 = 52,550
24,526 = 24,550

Round to the Neares 100
 

How do you determine whether a number gets rounded to 50 or 100?

55,769 = 55,800
52,562 = 52,550

Why is the first number rounded to 100 and the second rounded to 50?

--
Biff
Microsoft Excel MVP


"Shazam" wrote in message
...
I am working on employee proposed salaries and need to round to the nearest
50 or 100, such as below. Please help.
Thank you.

55,769 = 55,800
60, 112 = 60,100
52,562 = 52,550
24,526 = 24,550

Round to the Neares 100
 

You are right. It needs to be to the nearest 50.

"T. Valko" wrote:

How do you determine whether a number gets rounded to 50 or 100?

55,769 = 55,750 52,562 = 52,550

Why is the first number rounded to 100 and the second rounded to 50?

--
Biff
Microsoft Excel MVP


"Shazam" wrote in message
...
I am working on employee proposed salaries and need to round to the nearest
50 or 100, such as below. Please help.
Thank you.

55,769 = 55,800
60, 112 = 60,100
52,562 = 52,550
24,526 = 24,550

Round to the Neares 100
 

try formula in A2 =ROUND(A1/50,0)*50 where A1 contains the first number you
wish to round to nearest 50 - worked for me.

"Shazam" wrote:

You are right. It needs to be to the nearest 50.

"T. Valko" wrote:

How do you determine whether a number gets rounded to 50 or 100?

55,769 = 55,750 52,562 = 52,550

Why is the first number rounded to 100 and the second rounded to 50?

--
Biff
Microsoft Excel MVP


"Shazam" wrote in message
...
I am working on employee proposed salaries and need to round to the nearest
50 or 100, such as below. Please help.
Thank you.

55,769 = 55,800
60, 112 = 60,100
52,562 = 52,550
24,526 = 24,550

Round to the Neares 100
 

try formula in A2 "=ROUND(A1/50,0)*50" where A1 is number to be rounded -
worked for me.

"Shazam" wrote:

You are right. It needs to be to the nearest 50.

"T. Valko" wrote:

How do you determine whether a number gets rounded to 50 or 100?

55,769 = 55,750 52,562 = 52,550

Why is the first number rounded to 100 and the second rounded to 50?

--
Biff
Microsoft Excel MVP


"Shazam" wrote in message
...
I am working on employee proposed salaries and need to round to the nearest
50 or 100, such as below. Please help.
Thank you.

55,769 = 55,800
60, 112 = 60,100
52,562 = 52,550
24,526 = 24,550

Round to the Neares 100
 

Try this formula...

=MROUND(A1,50)

Note that the MROUND function requires the Analysis ToolPak add-in (which
can be selected from Tools/Add-Ins on the menu bar).

--
Rick (MVP - Excel)


"Shazam" wrote in message
...
You are right. It needs to be to the nearest 50.

"T. Valko" wrote:

How do you determine whether a number gets rounded to 50 or 100?

55,769 = 55,750 52,562 = 52,550

Why is the first number rounded to 100 and the second rounded to 50?

--
Biff
Microsoft Excel MVP


"Shazam" wrote in message
...
I am working on employee proposed salaries and need to round to the
nearest
50 or 100, such as below. Please help.
Thank you.

55,769 = 55,800
60, 112 = 60,100
52,562 = 52,550
24,526 = 24,550

Round to the Neares 100
 

Hi,

If you are using 2007 MROUND is built into Excel and there is no need to
attach the analysis toolpak.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Rick Rothstein" wrote:

Try this formula...

=MROUND(A1,50)

Note that the MROUND function requires the Analysis ToolPak add-in (which
can be selected from Tools/Add-Ins on the menu bar).

--
Rick (MVP - Excel)


"Shazam" wrote in message
...
You are right. It needs to be to the nearest 50.

"T. Valko" wrote:

How do you determine whether a number gets rounded to 50 or 100?

55,769 = 55,750 52,562 = 52,550

Why is the first number rounded to 100 and the second rounded to 50?

--
Biff
Microsoft Excel MVP


"Shazam" wrote in message
...
I am working on employee proposed salaries and need to round to the
nearest
50 or 100, such as below. Please help.
Thank you.

55,769 = 55,800
60, 112 = 60,100
52,562 = 52,550
24,526 = 24,550