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
Bookmarks