Need some help with Excel 2003..?

D

djsurreal3

I have list selection cell with 4 words in it. i want another cell to display
1 value if one of the four words is selected and another if the other three
are selected... basically a list with a,b,c,d and another box that will
display x if a,b,c are selected and y if d is selected. I tried
=if(c17="a","x",""), etc... along with =if(c17="d",y","") and all I get back
is TRUE not my x or y... HELP!!!
 

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

Help with creating drop down 1
Compare Two Columns 3
Need to return to display 3
Permutations andText to column problem 6
IF COUNTIF - Need Help with multiple criteria 4
excel days counting formula 1
Select row in formula in excel 2007 2
Need help with Time Stamp Code 2

Top