# creating a repeating formula that doesn't show repeating values

1. ## 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

2. ## Re: creating a repeating formula that doesn't show repeating values

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1