| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Use of more then 7 nested if statement
I used if statement in the form of
=IF(A34=A2,C34,IF(A35=A2,C35,IF(A36=A2,C36,IF(A37= A2,C37,IF(A38=A2,C38,IF(A39=A2,C39,IF(A40=A2,C40,I F(A2="","","Un Known")))))))) (It means if cell A2 is equal to A34 then print C34 and if cell A2 is equal to A35 then print C35 and respectively others and if cell A2 is equal to then cell C2 is equal to and if these all things are false then print Un Known ) (I used this formula in cell C2) Here I used only 7 nested if statement. But now I want to use more then it nearly 500 nested if statement. Please help me and guide me about this problem Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use of more then 7 nested if statement | Excel Worksheet Functions | |||
| Employing constant arrays to limit nested IF statements. | Excel Worksheet Functions | |||
| 7+ nested if statement? | Excel Worksheet Functions | |||
| nested ifs | Setting up and Configuration of Excel | |||
| nested statements | New Users to Excel | |||
Hybrid Mode
