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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting 7 statements
For what you are doing you are better off with a vlookup or similar type of
formula. -- HTH... Jim Thomlinson "Eden397" wrote: 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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nesting 7 statements
=LOOKUP(W2,{"BP","DM F","DM M","1 WEEK","0 WEEK","DG F","DG
M"},{"N/A","F","M","U","U","UNK","UNK"}) hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Jim Thomlinson" escreveu: For what you are doing you are better off with a vlookup or similar type of formula. -- HTH... Jim Thomlinson "Eden397" wrote: 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) |
Reply |
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 |