Nesting 7 statements

E

Eden397

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)
 
J

Jim Thomlinson

For what you are doing you are better off with a vlookup or similar type of
formula.
 
M

Marcelo

=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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If, And, Or Formula 2
Pulling multiple arrays from worksheets 1
Search Column for matches to a Range of Data, then modify cell 1
Macro to pop up a legend on screen (of sorts) 3
Load into Array rather than Hard Coded 14
AllInternalPasswords.xls 14
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Embedding operators, IF(x="up",>,<)IF.. 1

Top