Forum Discussion
need a formula function that takes pos & neg data from separate cols and displays results in another
I have an 8 column spreadsheet that I'm trying to set up in order to maintain my church's financial records. Column b is for deposits. Column d is for expenses/withdrawals. What formula do I enter...
Let's say the data begin in row 2.
In G2: =B2-D2
In G3: =G2+B2-D3
Fill down from G3
Hans my data actuaoly begins on line 3 so I just took your formula and changed the line and cell # by one but the solution didn't work.HansVogelaar
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
