Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am running some simple percentage formulas, but the rounding errors are
driving me nuts.. If I add the numbers and use that to find my percentage it gets closer to the 100% total each should have. However, if I use a formula such as: =G16/(SUM(G16:I16)) The rounding can be off by a couple of numbers. Cells G16 and I16 are total cells, for a column of numbers. =SUM(G7:G15) I have made sure the analysis tool pack is installed, and yet my numbers continue to be off. I do not remember running into this problem in 2003. Is there a fix, is anyone else having these problems? Thanks, Jacqueline |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Decimal rounding causing addition errors | Excel Discussion (Misc queries) | |||
Compensating for Excel rounding errors | Excel Discussion (Misc queries) | |||
How do I correct rounding errors in Excel formulas? | Excel Worksheet Functions | |||
Can rounded numbers be summed without rounding errors? | Excel Discussion (Misc queries) | |||
Rounding Errors Help | Excel Discussion (Misc queries) |