Saturday, November 23, 2013

yogi_Given Starting Balance And Expense Line Items Compute Row By Row Running Balance

                                          Google Spreadsheet   Post  #1430
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 23, 2013
question by landau calrissian (http://productforums.google.com/forum/?zx=ff6715r8y4lx#!category-topic/docs/spreadsheets/vfw34Ry3CGg)
IF/OR Statement to keep a running bank balance
Hello All,

I am developing a simple accounting system that categorizes expense and income for an event. I have created a Chart of Accounts on a Sheet which assigns every income and expense category and number. Another sheet is the General Ledger. Every transaction at the event will go into this Sheet and be categorized with the amount of income or expense on detailed. I would like to create a final column on the General Ledger which keeps a running balance after each transaction (row) of what the cash balance is. Starting cash for the event is $5000.

I tried doing this by creating 2 formulas. One in J2 and one in J3 on the General Ledger Sheet. The J3 formula I expanded down the column. Even though these formulas seem logically right, the result is that the formula keeps subtracting (giving the ELSE result) rather than adding when the condition of an income category is met. 

I'm sorry if I don't know the terminology for this stuff. I am a beginner with programming . 

Here is a copy of the Spreadsheet if anyone can help.


Thanks,

Nmax
--------------------------------------------------------------------------------------------------------------------------