Round to the Neares 100

[Shazam]

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

 

[T. Valko]

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?

 

[Shazam]

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

 

[pkeegs]

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.

 

[pkeegs]

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

 

[Rick Rothstein]

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

 

[Shane Devenshire]

Hi,

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