Sum does not add up
The problem is not in the formatting, but in the values. Re-format All the
values, including the sum as Number with 8 decimal places.
You should see that you will have to use the ROUND() function to get the
desired result.
--
Gary's Student
gsnu200708
"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
|