Please help me find where this error is coming from.

Occasional Contributor


Personal Finances Workbook.

Simple Transactions Table (Currency so 2 decimal digits)

No Interest Calcs or similar.

Formula to derive balance on the selected account is:-


Not much room for error there!

After about 35 transactions to the account I am getting a figure which should be 0 of:-



Where is this coming from please?

I’m baffled!

Many thanks.


2 Replies
best response confirmed by Grahmfs13 (Microsoft)

@JonnieMorgan Google for "Floating point error" and just accept it. When you notice something like this wrap the formula in a ROUND function. So, in your case use:




Thank you!
That's obvious now it's been explained to me!!