With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Tuesday, November 25, 2014
yogi_Compute Row By Row Balance For A Check Register Type SetUp With Starting Balance
I created a check register spreadsheet and would like to use an array formula to calculate the balance in a more efficient manner as opposed to a formula for each cell. The problem is that I have to subtract from the cell above in the prior row. This is the formula:
I can't figure out how to subtract from the cell/row (F2-999) in the row above while using the proper syntax for the array formula. It is also calculating a balance when cells in D and E are blank, but it shouldn't.