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

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

It maybe easier next time to use some row like "1" rather than 'n', and not
neccessary to put the column in [ ] either.. just makes it harder to read.

Try

=IF(AND(e2="",f2=""),"",g1-e2+f2)

You also don't need the SUM there, and I think I understood you want to pull
from the row above where you wrote 'n-1' ...



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

Dave R,

Thanks a lot for the expression which does just what I want.

Once you see the syntax it is almost blindingly obvious.

I guess the Halvorson reference is particularly good if all you really
want to do is make cosmetic changes.

Thanks too for your advice on how to express oneself when writing to a
newsgroup.

Rednelle


"Dave R." wrote in message
...
It maybe easier next time to use some row like "1" rather than 'n', and
not
neccessary to put the column in [ ] either.. just makes it harder to read.

Try

=IF(AND(e2="",f2=""),"",g1-e2+f2)

You also don't need the SUM there, and I think I understood you want to
pull
from the row above where you wrote 'n-1' ...



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