I am tracking monthly loan payments. Column I indicates whether the bill has been paid yet with a simple "yes" or "no" value, and Column J indicates the remaining balance of the loan. I want every cell in Column I of my worksheet to confirm whether or not the remaining balance has been entered into the adjacent cell in Column J. The value entered into each cell in Column J is a subtraction of the value in the preceding J cell and a value in cell L5. If a cell in Column J does not have that value entered, I want Column I to reflect that with "no"; if Column J does have that value, I want Column I to reflect with "yes".
This is the equation I started with and would love some help figuring this out. Screenshot of the table included. Thanks!
=IF(OR(J8-L5, "yes", "no"))
