Hello,
Using this formula for a bank account,
=IF(SUM(C2-A1+B1)=C1, "match", "NO match")
down a column of about 3000 rows,
yields only one cell with an unexpected and probably incorrect response in G2 with a "NO Match" - where the math is correct ?
Can someone please explain - I'm curious as to why this happens.
Thank you kindly,
A B C D
63.58 0.00 -54.97 match
64.57 0.00 8.61 NO match
128.21 0.00 73.18 match
201.39
Details:
Attachment is included;
temp2.xlsx
in a bank account file, where "C2" is the previous balance, "C1" is the current balance,
"A1" is any check written, "B1" is any deposit applied.
Bookmarks