Thread: creating a repeating formula that doesn't show repeating values

I am trying to make a worksheet like a bank book. I want the formula to update the next cell on the next row without showing the balance all the way down. So if I have the balance in row k2 and I input a value in row a3 then k3 should deduct the balance from k2 and put it in k3 and so on all the way down. This is the formula I tried

=SUM(K2:K90-G3:G90+I3:I90)

the G column would be debits, the I column is credits

Hi Cybershot, welcome to the forum.

Perhaps this formula in K3 and filled down:

=IF(OR(G3<>"",I3<>""),K2-G3+I3,"")

If both G3 and I3 are blank, K3 will remain blank. If either has a value it will take the balance in the cell above and subtract anything in column G of that row, then add anything in column I of that row.