Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Calculation issue not fixed.
When calculating a range of numbers I get this: 114,642.55 good When I add another range of numbers I get this: 165,707.09 good Now when I try and subtract those two summed fields 165,707.09 from 114,642.55 is get this: 51,064.46999999 wrong I should get this 51,064.47. How can this be? I know I can format the field to show the 51,064.47 but the value is 51.064.46999 which after thousands of additions and subtractions that fraction of a decimal will add up. I am on service pack 2 for office. It works fine if you just type in the numbers into two fields but when you subtract the cells with the functions in them, they do not work. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel formula is calculating wrong total number on some of cells | Excel Worksheet Functions | |||
Wrong Teaching of Excel | Excel Discussion (Misc queries) | |||
Autosum Calculating Wrong | Excel Discussion (Misc queries) | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
Easy calculating ending with wrong decimals | Excel Discussion (Misc queries) |