I've been learning how to use conditional formatting and decided to apply it to my bank account records that I have stored in Excel. I wanted to check for missing sections in my statement in case I lost any transactions when exporting the data in little chunks at my internet banking website.
I built my conditional formatting around a straightforward true/false rule.
= Balance = PreviousBalance minus Debit plus Credit
In a handful of rows this is throwing up a False when balance is correct. After some playing around I discovered that Excel was introducing an error at the 14th decimal place.
When A1 is 67.13, A2 is 72.43, Excel calculates =A1-A2 as -5.3000000000000100000
Some Googling led me to this post at Microsoft Answers. But I don't understand how/where I am supposed to be using the Round function.
[Excel 2007, Windows 7.]
I built my conditional formatting around a straightforward true/false rule.
= Balance = PreviousBalance minus Debit plus Credit
In a handful of rows this is throwing up a False when balance is correct. After some playing around I discovered that Excel was introducing an error at the 14th decimal place.
When A1 is 67.13, A2 is 72.43, Excel calculates =A1-A2 as -5.3000000000000100000
Some Googling led me to this post at Microsoft Answers. But I don't understand how/where I am supposed to be using the Round function.
[Excel 2007, Windows 7.]
Last edited:
