Hello!
I am making a budgeting spreadsheet, showing finance/credit taken out, and how it reduces over time.
I have a cell for the amount of credit "3,455.28" (C4), a cell for the monthly repayment "98.72" (D5) and cells E4 onwards to show monthly values.
I use cell E2 to show the monthly value being 'paid', this is something I would manually enter a value for to update the spreadsheet.
Formula is as shows:
FOR CELL E4: =IF(E2>0,C4-D4,C4). With a number 1 in E2, the value will be adjusted to show 3,356.56, without a 1 it would show the value in C4.
FOR CELL F4: =IF(F2>0,E4-D4,E4) - Same as the above but with the value 2 in F2.
FOR CELL G4: =IF(G2>0,F4-D4,F4) - Same as above but value 3 in G2.
Now comes the problem, if I highlight cell F4 and G4, copy it across (stretch the formula), the formula in cell H4 becomes =IF(H2>0,G4-F4,G4). Entering 4 in H2 would give a value -98.72.
The formula works with manual inputs, but when copying across, it glitches as described. When copying down, it would change (for cell E5) E3, instead of E2, for the manual input.
I'm having a complete nightmare with it, what am I doing wrong?
Please help!
Bookmarks