IF statements

  • Thread starter Thread starter oatjes
  • Start date Start date
O

oatjes

Can you have 2 If statements in a formula without having to do Visual Basic?
 
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
 
Yes, Excel will allow you do include up to 7 nested "IF-THEN-ELSE" statements
within a formula
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula for double If statements 4
Multiple if statements 5
TRUE/FALSE STATEMENT 4
IF OR Statements 4
macro to fill in rows with blanks 5
IF and THEN statements 5
IF/OR Statement 4
Macro or VB code to hide and unhide Label box 1

Back
Top