=In - Out = Bal
=Bal + In - Out = Bal
Put this in Cell C1 =A1-B1
Put this in Cell C2 =C1+A2-B2 Drag down column C
"ecurb849" wrote:

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.