I am working on a very simple spreadsheet to check a loan balance by
subtracting last months reported principal to this months reported
principal and checking that against the amount of money paid toward the
principal. So, I have the function =IF(G4-G5=E5, "Yes", "No") where G4
is last months principal balance, G5 is this months reported principal
balance, and E5 is the amount paid toward principal balance. If the
reduction in principal matches the amount paid, then everything is
good. It all checks out (in excel and hand calculations) that the
reduction and paid principal match, BUT, it keeps displaying No?????
Why?? I have tried different variations where I have G4-G5 in another
cell and compair that cell to E5 and have tried doing IF(E5-whatever
cell the diff is in=0, "Yes", "No") but that won't work. Why doesn't
excel see the if statement as true when it is?

Thanks.


--
blakrapter
------------------------------------------------------------------------
blakrapter's Profile: http://www.excelforum.com/member.php...o&userid=28926
View this thread: http://www.excelforum.com/showthread...hreadid=489873