Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |