Need some help with Excel 2003..?
 

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

Need some help with Excel 2003..?
 

Try =IF(G1="d","y","x")

HTH
Regards,
Howard

"djsurreal3" wrote in message
...
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!!!