Sure, you can nest them one within the other:

=IF(Condition1,True1,IF(Condition2,True2,False2))

or

=IF(Condition1,IF(Condition2,True2,False2),IF(Cond ition3,True3,False3))

In Excel 2003 you can have up to 7 nested levels. I don't remember what it
is for either earlier versions or Excel 2007. Look up Nested functions in
help for details on your release
--
Kevin Backmann


"oatjes" wrote:

Can you have 2 If statements in a formula without having to do Visual Basic?