Help does not put the = in front of the worksheet formulas, because they can be stacked inside one another, but this can lead to confusion.
Look at the syntax in Excel HELP for IF Worksheet Function
nesting the TRUE portion only:
=IF(logical_test1, IF(logical_test2,value_if_true2,value_if_false2), value_if_false1)
I added numbers to help make the above more readable. You can plop
another IF(test,true,false) into the true action part or the false action part.
There is a limit of seven levels of nesting ...
by which time you would be pretty much lost anyway if you tried to maintain the formulas.
Chip Pearson has a page on nesting IF statements, don't think that
will help as much as the HELP in Excel with the above information.
But we try to do things explain a few things better than HELP and may
or may not succeed.
Where Chip's pages shine in this area is a way to overcome the limit of seven levels by using named ranges.
Another alternative to heavy nesting of IF statements may be the VLOOKUP Worksheet Function.
Use of OR Worksheet Function to reduce need for nesting:
Excel Function Dictionary « by Peter Noneley is a reference to definitely download and maintain on your computer, the workbook has 157+ sheets each with an explanation and example of an Excel function.
Better Solutions, Russell Proctor, lots of indexed information on Excel and Word. Links are denoted by color and not by underlining.
IF condition THEN action; Else other_actionand those that don't go on one line
IF condition THEN action1 action2 ElseIf condition Then action3 Else action4 End IFin the above since you are using multiple lines you cannot use "Else action4" on one line. Note the difference, VBA is not as free form as many other languages.
Visit [my Excel home page] [Index page] [Excel Onsite Search] [top of this page]
Please send your comments concerning this web page to: David McRitchie send email comments
Copyright © 1997 - 2004, F. David McRitchie, All Rights Reserved