an IF question

[bionicle]

Hi all, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
A real basic request that for some reason my brain just can't get....<o></o>
<o></o>
I've created a simple drop down list that returns a value of "yes" or "no" what I'm trying to do is to populate the adjacent cell with a statement lets say " go away" only why "yes is selected.<o></o>
<o></o>
Your help and guidance would be appreciated.<o></o>

 

[Sektor]

=IF(A1="yes","go away","")

 

[Expiry]

=IF(A1="yes","Go Away!","")

change the A1 to whatever cell the yes will be in.

 

[Trevor G]

=if("A2"="Yes","Go Away","")

 

[bionicle]

thank you for a very speedy response.

works a treat.

 

[Sektor]

Trevor, did you check your formula?