| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statements
Can you have 2 If statements in a formula without having to do Visual Basic?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statements | Excel Worksheet Functions | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| IF and MAX statements | Excel Worksheet Functions | |||
| if statements, and statements | Excel Worksheet Functions | |||
| If-Then Statements | Excel Worksheet Functions | |||
Linear Mode
