View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Shazam Shazam is offline
external usenet poster
 
Posts: 11
Default 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