In the screenshot above in Excel I have opened a CSV file of money transactions from my bank. The transaction date is in column
A, the amount in
B, and the bank's computed balance in
D. I'm computing my own running balance in column
=SUM($A$2:An)) and column
H provides a highlight to indicate any discrepancies (
=IF( Dn = "", TRUE, Fn=Dn ), unfortunately as the screenshot shows, Excel is saying that
£898.15 does not equal
I wanted to see if there was a rounding-error going on, so in column
K I set the formula
=Dn-Fn and then expanded the number of decimal places shown. Which shows a minute error of
Question 1: Where is this insignificant error coming from, and why does Excel suddenly consider the values different in row 206?
Question 2: Other rows have an identical discrepancy (e.g. 188 and 184 vs. row 206) so why does Excel complain all of a sudden?
Question 3: Why isn't Excel treating currency values as integral values and not floating-point, so there shouldn't be any error at all.