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 |