=IF(COUNT(B2,C2)=1,D1+B2-C2,"")
--
David Biddulph

"DocBrown" wrote in message
...
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

"Peo Sjoblom" wrote:

It does include relative references. It is a typical balance formula
where you refer to the cell above as well

--


Regards,


Peo Sjoblom

"GA85" wrote in message
...
I know it needs to include some type of relative or absolute
reference...

"David Biddulph" wrote:

In C2, use the formula =C1+A2-B2, and copy down.
--
David Biddulph

"GA85" wrote in message
...
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????