Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
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
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
No comments:
Post a Comment