| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting 7 statements
The cell W2 has the option of being 7 different text variables. I want to do
an if/then formula but can't seem to next it appropriately. Can anyone help? Thanks. =IF(W2="BP","N/A",0),IF(W2="DM F","F",0),IF(W2="DM M","M",0),IF(W2="1 week","U",0),IF(W2="0 week","U",0),IF(W2="DG F","UNK",0),IF(W2="DG M", "UNK",0) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workaround for nesting more than 7 statements | Excel Discussion (Misc queries) | |||
| Nesting IF statements | Excel Discussion (Misc queries) | |||
| nesting if statements | Excel Worksheet Functions | |||
| Nesting more than nine IF statements in Excel | Excel Worksheet Functions | |||
| Nesting IF Statements Based on Same Cell Value | Excel Worksheet Functions | |||
Threaded Mode
