View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacqueline Jacqueline is offline
external usenet poster
 
Posts: 17
Default Rounding Errors in 2007

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