View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Sum does not add up

It's all to do with decimal places, Try extending the number of decimals that
excel displays and I think you will see that Excel is getting it right.

If having the answer display like this is a problem then look at ROUND in
the help section.

Mike

"Alex" wrote:

I have the following table and cant get it to add right. I have tried Sum and
just adding the cells but it is always off by one cent.

304.63
0.00
0.00
0.00
0.00
0.00
29.57
0.00

334.21

I ahve all the cells invloved formatted the same.

HELP...
Alex