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 `F`

(`=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 `£898.15`

.

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 `-0.00000000000272848`

.

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.