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

Nested IF Statement 3 Conditions, Need Help Fixing 7
If, And, Or Formula 2
Page numbering with Merged Document and IF statements 1
Stair Step commissions question 3
Stair-step commissions question 2
"Stair-Stepped" Commissions Question. 2
SUBSTITUTE formula -- variable spacing between parameters?? 3
Find right cell (with duplicate values) 0

Top