| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I create an "IF" statement with more than 7 levels?
I am creating a worksheet that inserts the "package price" when the operator
enters the "Package #". There are 20 possible package numbers. How can I do this when my "IF" statements are limited to 7 nesting levels? |
|
#2
|
|||
|
|||
|
You can only do up to 7 Nested IF statements. Have a look in the Help Files
for VLOOKUP for an alternative. tj "Jack of All Trades" wrote: I am creating a worksheet that inserts the "package price" when the operator enters the "Package #". There are 20 possible package numbers. How can I do this when my "IF" statements are limited to 7 nesting levels? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create invoices | New Users to Excel | |||
| create a drop down list with the source from a different workbook | Excel Discussion (Misc queries) | |||
| trying to create | Excel Discussion (Misc queries) | |||
| Use Julian Date To Create Serial Number | Excel Discussion (Misc queries) | |||
| How do I create a total sheet that will pull info from all my she. | Excel Worksheet Functions | |||
Hybrid Mode
