O
oatjes
Can you have 2 If statements in a formula without having to do Visual Basic?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kevin B
Sure, you can nest them one within the other:
=IF(Condition1,True1,IF(Condition2,True2,False2))
or
=IF(Condition1,IF(Condition2,True2,False2),IF(Condition3,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
=IF(Condition1,True1,IF(Condition2,True2,False2))
or
=IF(Condition1,IF(Condition2,True2,False2),IF(Condition3,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
J
Joe Mac
Yes, Excel will allow you do include up to 7 nested "IF-THEN-ELSE" statements
within a formula
within a formula
O
oatjez
Would this also work with Excel 2000 version??
K
Kevin B
Sure would...
--
Kevin Backmann
--
Kevin Backmann
oatjez said:Would this also work with Excel 2000 version??