Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You will first have to explain your rounding algorithm, since it is not
obvious from your examples. Jerry "sloancm" wrote: I am looking at a more accurate way to round numbers off. The problem is that excel wants to stick to the simple method. I am looking for a formula that looks at the digits beond the five for exaplme 8.356=8.4, 8.353=8.3, 8.355=8.3. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I correct rounding errors in Excel formulas? | Excel Worksheet Functions | |||
Rounding and Number Formatting | Excel Discussion (Misc queries) | |||
Problems: rounding & formatting Text/# combinations | Excel Discussion (Misc queries) | |||
Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
Banker's Rounding - need help! | Excel Discussion (Misc queries) |