IF statements
 

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

IF statements
 

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?

IF statements
 

Yes, Excel will allow you do include up to 7 nested "IF-THEN-ELSE" statements
within a formula

--

Joe Mac


"oatjes" wrote:

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

IF statements
 

Would this also work with Excel 2000 version??

"oatjes" wrote:

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

IF statements
 

Sure would...
--
Kevin Backmann


"oatjez" wrote:

Would this also work with Excel 2000 version??

"oatjes" wrote:

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