Glad you got it sorted.

Just for the record Mike's formula is more efficient
so the final formula should be
IF(COUNT(A2:B2)=0,"",C1+A2-B2)

Regards
Martin


"ecurb849" wrote in message
...
Thankyou just what I wanted.

"MartinW" wrote:

Hi, try this

Put this formula in C2 and drag down as far as is needed
=IF(COUNT(A2:B2)=0,"",IF(A2,C1+A2,C1-B2))

Put your starting balance in C1
Your first input cell is either A2 or B2

To drag a cell,
Click on the cell
Hover your cursor over the liitle box at the bottom right of cell
When your cursor changes to a small cross click and hold
on it and drag it down to where you want, then let it go.

HTH
Martin


"ecurb849" wrote in message
...
How do I enter a formula that self calculates every time data is
entered
such as in out and balance

in out bal
100 100
100 200
50 150 every time something is entered in the in collum
or
the out collum
the balance automaticly changes.