sandradavis
New Member
I need a formula to calculate running balance. My first column is called Balance. I enter an initial balance/amount of $20,000 on cell A2. The next column is Profit and the third column is Loss. If I enter an amount under the Profit column (on cell B2 to be exact) then it adds that amount to the initial balance (A2). The sum or new balance should be automatically calculated on cell A3. If I enter an amount under the Loss column (on cell C2) then it subtracts that amount from the initial balance (A2). The new balance should be automatically calculated on cell A3. The automatic calculation or formula starts from cell A3. Next, if I enter an amount either on cell B3 or C3 then cell A4 would automatically calculate a new balance (either adding to the amount on cell A3 or subtracting). Then, so and and so forth... Thanks for your help!
