Hi
in G2 put
=IF(AND(E2="",F2=""),"",G1-E2+F2)
and copy this down

in G1 you probably have to enter a formula such as
=IF(AND(E1="",F1=""),"",-E1+F1)

--
Regards
Frank Kabel
Frankfurt, Germany

"Rednelle" schrieb im Newsbeitrag
...
Greetings from a newbie,

I hope I am in the right group for this query, if not please redirect
me.

I cannot understand, from Microsoft Help or from Halvorson's 'Running
Office
2000', how to create a nested function.

I am building a simple worksheet with 3 columns: debit [e], credit
[f],
balance [g].
I want to put a function/formula in the balance column - lets say for
row
'n' -

IF [e]'n' is blank AND [f]'n' is blank then display [g]'n' blank else
display [g]'n' = Sum ([g]'n-1' - [e]'n' + [f]'n')

So when I copy the expression down column 'g' and then print the
sheet I
don't see anything in fields [g]'n+1' thro [g]'n+x'

Could someone please write the expression for me, and post, so that I
can
see the syntax.

Thanks in advance.

Rednelle