Please help me find where this error is coming from.

[JonnieMorgan]

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:-

=(SUMIFS(TrAmount,TrAccName,B4))

Not much room for error there!

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

-£0.000000000000028421709430404

Where is this coming from please?

I’m baffled!

Many thanks.

Jon

[#2 · Accepted solution]

@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:

=ROUND(SUMIFS(TrAmount,TrAccName,B4),2)

[#3]

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