Prev: Two completely unrelated workbood. Why is it asking me about updating links? SOLVED!
Next: DTPicker control bug
From: djsurreal3 on 29 Jan 2010 19:54
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!!!
From: L. Howard Kittle on 29 Jan 2010 22:15
Try =IF(G1="d","y","x")

HTH
Regards,
Howard

"djsurreal3" <djsurreal3(a)discussions.microsoft.com> wrote in message
news:69B89F01-B149-4DDC-B983-72B04EEE3B3D(a)microsoft.com...
>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!!!


 | 
Pages: 1
Prev: Two completely unrelated workbood. Why is it asking me about updating links? SOLVED!
Next: DTPicker control bug