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!!!