+ Reply to Thread
Results 1 to 2 of 2

creating a repeating formula that doesn't show repeating values

  1. #1
    Registered User
    Join Date
    12-08-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    11

    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
    Last edited by cybershot; 12-08-2010 at 11:49 PM. Reason: changing the title

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,799

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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