| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Hi,
the syntax for nested If statements in Excel is as follows.. Single IF Statement... =If(Cond1,Value if True,Value if False) Nested IF Statement =If(Cond1,True,If(Cond2,True,IF(Cond3,True,False)) ) where the 2nd IF statement is evaluated when Cond1 is false... It's worth noting that 2nd IF (or any following) will not be evaluated if the first condition is TRUE. This is different from VB's IIF statement. You can use upto 7 nested IF statements in a formula. Hth, Oli -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I use multiple nested functions? | Excel Worksheet Functions | |||
| ENTER EXCEL FORMULA WITH MORE THAN 7 NESTED FUNCTIONS | Excel Worksheet Functions | |||
| Data calculations require more than 7 nested functions | Excel Worksheet Functions | |||
| Too many nested functions | Excel Worksheet Functions | |||
| Data calculations require more than 7 nested functions | Excel Worksheet Functions | |||
Threaded Mode
