Balances

  • Thread starter Thread starter GA85
  • Start date Start date
G

GA85

Ok, suppose my sheet looks like the following:

A B C
Debit Credit Balance
100 100
300 400
50 350

I just typed those values in but I would like to have Column "C" compute
that if the amount is column "A" then add to get the balance in column "C";
and subtract if the amount is in column "B" . I would like for this formula
to be able to go all the way down column C. ANYONE????
 
your first formula in the column c will be =a1-b1
and your second formula in column c is =$C1+A2-B2
then drag the formula down as many rows as you need. Hope this helps.
 
It does include relative references. It is a typical balance formula
where you refer to the cell above as well

--


Regards,


Peo Sjoblom
 
The below would accomplish what you initially requested. Since there is no $
in the formula, the references are relative, but that needn't be the case.

Is there a more complex request hidden within this that may require futher
difficulty?
 
One additional question on this.

This makes the balance visable down the entire Balance column. How do you
make this display a balance only when there are entries in Columns B and C?
Yet still keep the running total correct? Like this:

Opening balance: 1000.00

A B C D
Item Depit Credit Bal
-------------------------------
Entry1 100 1100.00
Entry2 150 950.00
Entry3
Entry4 200 1150.00

(nothing displayed here on down...)

Thanks,
John
 
I'm not sure this works.

Let's say that C and D in row 'Entry3' has no values, then the 'if' is
false, and no value is placed in the D column. But now Row 'Entry4' has no
value to use in the calulation and the error #VALUE! occurs.

Am I missing something?
 
Back
Top