Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding 1,000s
I have a budget where I rounded to the 1000's by taking the number and
dividing it by 1000. So for example: 2,000,000 is now 2,000 (=2000000/1000) The problem is ... Excel is not rounding correctly, please see below. How do I fix this? Example : #/1000 253,462 253 127,033 127 34,500 34 (why did Excel round this down?) 28,633 29 443,627 444 on a calculator 443 Thank you, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I correct rounding errors in Excel formulas? | Excel Worksheet Functions | |||
Significant number rounding based on key cell | Excel Worksheet Functions | |||
Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
Rounding | Excel Discussion (Misc queries) | |||
Banker's Rounding - need help! | Excel Discussion (Misc queries) |