Hello!
I've had an ongoing battle with this for quite some time.
We download a finance sheet from the bank in excel format and we are supposed to Balance transactions against the same dollar amount entered manually.
The problem, however, is as old as time: Downloaded transactions can look like: 660.45, but when expanding the cell, it is truly: 660.4500000000200
We have a calculated cell where it will read "OK", or "Off Balance". When this happens it says "Off Balance" but we're willing to forgive the micro-variance.
I've tried to do IF conditions that say "If variance is greater than or less than 0.001" then calculate "OK" but the problem is that sometimes the micro variance happens closer to the decimal period than other times.
Can anyone please offer a suggestion as to how the formula should look like? I've attached a sample sheet to this post.
Thank you!!!
Bookmarks