| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MULTIPLE NESTING WITHIN EXCEL
I'm fairly comfortable working within Excel; however, I just know there must
be a work-around for multiple nesting requirements that I probably simply just do not know of. Specifically, I am looking for either the correct argument/formula or "trick" to be able to complete an entry such as the following: =IF(B18=136,"97",IF(B18=816,"97",IF(B18=160,"97",I F(B18=817,"97",IF(B18=138,"1",IF(B18=6848,"1",IF(B 18=8527,"1",IF(B18=8954,"447",IF(B18=1773,"447",IF (B18=163,"447",IF(B18=1772,"447",IF(B18=155,"448", "")))))))))))) I would appreciate any time you are able to spend with this request. -- Thanks. George* |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting COUNTIF for multiple criteria in multiple columns | Excel Worksheet Functions | |||
| Nesting "If" in Excel | New Users to Excel | |||
| Help with nesting functions in Excel | Excel Worksheet Functions | |||
| Nesting more than nine IF statements in Excel | Excel Worksheet Functions | |||
| Multiple Criteria IF Nesting | Excel Worksheet Functions | |||
Threaded Mode
