New
#1
Excel Formula Help please...
This is probably very simple and I have got it working but it isn't working how I want it to work.
I have created an Excel document to show my monthly payments of a bank loan. I have created 3 columns in the first column is the payment number, in the second column is the amount that the loan is after I have made a payment, and in the third column I want to know how much the loan has been reduced by after the bank has taken interest off.
I have just put this formula in the 3rd column, =SUM(D4-D5), and then dragged this formula down into all the other rows I want this to work in which it does. The problem I am having with this is that the number from the 2nd column get placed in the 3rd row, below the amount that has been reduced, and I would like it to stay at £0.00 as it looks better.
Here is what I mean
If you notice the number I enter in the balance column appears in the reduced by column, and I don't want it too because it looks very unprofessional.
Can someone please help me out with this please.