Forum Discussion
Solved
Please help me find where this error is coming from.
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,TrAc...
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)
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)
- Thank you!
That's obvious now it's been explained to me!!
Regards
Jon
