Google Sheets: Formula not copying across properly

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!

It is easier to help when we have actual data (typed manually if necessary) with which to work.
I made up some values and did some rearranging on the Monthly Balance sheet, switched Monthly Payment and Opening Balance, to come up with that which I feel you are looking.
The formula for rows 4:5 on the Monthly Balance sheet is: =IF(E$2="x",$D4-$C4*COLUMNS($E4:E4),D4)
The formula for Balance on the Credit sheet is: =B3-C3
The formula for the Total Outstanding column: ='Monthly Balance'!BH4
Let us know if you have any questions.

You should have started a new thread for this.

Do NOT change the title of a thread unless a moderator asks you to do so.

Do NOT ask a new question in an old thread - I will let it go THIS time.

I am moving this to the correct forum section as it appears to be about Google Sheets, not Excel.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.