View Single Post
  #1   Report Post  
Rednelle
 
Posts: n/a
Default Conditional functions

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