Hi Michele

I think JE McGimpsey summed it up perfectly

"for the SUM(J7:Jx) part. It's an inherent problem with representing
finite decimal numbers in binary (just like in decimal, nearly ALL
numbers can't be represented in a fixed number of binary digits).

When performing operations on currency it's usually helpful to use
ROUND(xxxx,2) to ensure that those small errors are discarded."


"Michele" wrote:

i reformated all my cells to 30 decimal places and the numbers look correct
and look as follows:
-400.000000000000000000000000000000
-923.450000000000000000000000000000
60.000000000000000000000000000000
36.000000000000000000000000000000
44.000000000000000000000000000000
283.180000000000000000000000000000
36.000000000000000000000000000000
36.000000000000000000000000000000
200.000000000000000000000000000000
145.100000000000000000000000000000
127.350000000000000000000000000000
35.500000000000000000000000000000
30.600000000000000000000000000000
162.600000000000000000000000000000
106.320000000000000000000000000000
20.800000000000000000000000000000
my beginning balance reads: 0.000000000000000000000000000000
but my ending balance is: 0.000000000000074606987254810500
i still don't understand if all this reads as above then how can there be a
rounding error.
Thank you all for helping me try to figure this out. i'm not argueing with
anyone, just trying to understand.