Forum Discussion
Solved
Really weird decimal amounts
Hi
I was disturbed with a very strange small decimal amounts (0.0000000000011) somehow added "from the sky" to the result of my formulas . The problem started from the cell highlighted in red i...
Hello,
this probably is caused by the floating point precision issue. Read up about that here:
Hi Grayson
I'm also going in circles with your mysterious numbers so no answer from me I'm afraid.
Question though, could you just reduce to two decimal places rather than doing miniscule fractions of cent?
Just another observation for whatever it's worth, you haven't put the debits in the correct column as they are all in the credits column as well as some other strange things in your formula such as column B having a + in front (e.g. =+A6).
Anyway best of luck Grayson, hope it works out!
Cheers
Damien