| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i set up formula to calculate to the neares 300 number | Excel Worksheet Functions | |||
| Round 1.45 down to 1.25 and 1.57 down to 1.50 | Excel Worksheet Functions | |||
| Don't Round... | Excel Discussion (Misc queries) | |||
| ROUND | Excel Discussion (Misc queries) | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Hybrid Mode
