View Single Post
  #2   Report Post  
RagDyeR
 
Posts: n/a
Default

Are these numbers in H8:H13 the results of formulas, or did you key them in
manually, where you can select the individual cells and see the actual
number in the formula bar.

I'll bet this is a rounding issue.

See this link of John McGimpsey:

http://www.mcgimpsey.com/excel/pennyoff.html
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"KimberlyC" wrote in message
...
Hi
I have the following numbers in H8:H13:
1.000
1.000
0.088
0.751
0.252
1.000

When I add these up in cell H7, using =Sum(H8:H13), the answer is 4.090.
It should be 4.091
Why is this happening....and how can I stop it from doing that or how can I
adjust my formula to make it add these numbers correctly?
Thanks in advance for your help!!

Kimberly :)