Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round to a particular tolerance
Hi All,
Is there a way to round to an even numbers, or odd. It doesn't really matter. Basically this is what I need: 120=120 121=120 121.999=120 122=122 123=122 124=124 125=124 126=126 127=126 128=128 129=128 130=130 or maybe even change it later to 120 to 122.999 = 120 123 to 125.999 = 123 etc... the one catch is, it must round down to that number. When I looked at 'rounddown' it only rounds to 1, 10, 100 etc. unless I am wrong thanks Chad |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round to a particular tolerance
Chad wrote:
Hi All, Is there a way to round to an even numbers, or odd. It doesn't really matter. Basically this is what I need: 120=120 121=120 121.999=120 122=122 123=122 124=124 125=124 126=126 127=126 128=128 129=128 130=130 =ROUNDDOWN(A1/2,0)*2 or maybe even change it later to 120 to 122.999 = 120 123 to 125.999 = 123 etc... =ROUNDDOWN(A1/3,0)*3 the one catch is, it must round down to that number. When I looked at 'rounddown' it only rounds to 1, 10, 100 etc. unless I am wrong thanks Chad |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Round to a particular tolerance
Hi,
Try this =MROUND(A1-1,2) This assumes your numbers start in cell A1. This is an analysis toolpak function, so if you are using 2003 or earlier, choose Tools, Add-ins, and check the Analysis ToolPak. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Chad" wrote: Hi All, Is there a way to round to an even numbers, or odd. It doesn't really matter. Basically this is what I need: 120=120 121=120 121.999=120 122=122 123=122 124=124 125=124 126=126 127=126 128=128 129=128 130=130 or maybe even change it later to 120 to 122.999 = 120 123 to 125.999 = 123 etc... the one catch is, it must round down to that number. When I looked at 'rounddown' it only rounds to 1, 10, 100 etc. unless I am wrong thanks Chad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
@ROUND | Excel Worksheet Functions | |||
exel conditional formula,calculate a bilateral tolerance(.2/-.2)? | Excel Discussion (Misc queries) | |||
Tolerance Stack Excel Worksheet | Excel Discussion (Misc queries) | |||
Changing the color of a list entry based on a tolerance | Excel Worksheet Functions | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions |