My maid Jaya has borrowed Rs. 2000/- from me to pay her daughter's school fees. She tells me to deduct Rs.200 from her salary every month. I want a spreadsheet that shows, the total amount she has borrowed, and the balance she has to repay as I deduct Rs. 200 every month.
This is the easiest way I can go about doing it.
Step 1: I've entered the month, the amount borrowed, and the amount she said I could deduct from her salary in the columns A, B, and C.
Step 2: For D1, I've assigned the value '=B1-C1'; Rs.1800
By October, you can see that she has paid all her dues.