Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
Conditional Formatting | Excel Worksheet Functions |