Hi,
the syntax for nested If statements in Excel is as follows..
Single IF Statement...
=If(Cond1,Value if True,Value if False)
Nested IF Statement
=If(Cond1,True,If(Cond2,True,IF(Cond3,True,False)) )
where the 2nd IF statement is evaluated when Cond1 is false...
It's worth noting that 2nd IF (or any following) will not be evaluated if
the first condition is TRUE. This is different from
VB's IIF statement.
You can use upto 7 nested IF statements in a formula.
Hth,
Oli
--
Message posted via
http://www.officekb.com