Hello I was wondering if anyone could help me with some calculations. I am creating a loan repayment schedule but cant seem to get some of these calculations working. I've attached pictures below. The total interest calc is in negative value and it shouldn't be it should be £109 instead. Also I am finding it difficult to calculate the total payment as it requires the total interest value. Also I am new to excel and I thought I would be able to drag these functions down to fill out the rest of the data although this doesn't seem to be the case and it gives me all sorts of errors.
Bookmarks