Sunday, January 22, 2012

yogi_Calculate Running Balance For Multiple Investment Line Items

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
user IamPalmer said:
I am trying to calculate a running balance on a multiple investment account.
I make an investment (Column A)
I either get a positive return, or a loss of the initial investment (Column B).
I want to be able to adjust my balance by deducting the loss (Column B negative number), or adding the positive return (Column B positive number) PLUS my initial investment (Column C) to the balance (Column D).
I am currently attempting to do this with multiple if/then's, but I have been unable to find a similar formula and I am too much of a newbie to figure this out.
I appreciate any help that anyone can provide!
following is a solution to the problem