Help needed with radiobutton and "IF" function

[andre4dee]

Hi there i need to do summing and i dont seem to come right. what i need to do is : i have 4 options (radio buttons) lets call them a ,b ,c ,d now i need to do my if statement "(=if a=selected,correct,"") but it does not want to select the radio button

 

[GlennUK]

Where are you putting this IF function? Can you post your exact attempt and not a pseudo English version of it, please? Which cells have been assigned as the LinkedCell for each button?

 

[andre4dee]

Glenn

The problem is that i cannot do my IF statement at all. My four radiobuttons are in cells C10-C14. i Want to do my "IF" statement in A9. What i am try to accomplish is that if a user selects the right option the Number 1 must be displayed in A9 that i use to do my scoring with.

Thanks

 

[Norie]

You say the radio buttons are 'in' the cells?

But are they actually linked to the cells?

 

[andre4dee]

Norie

Thanks for your reply , its working now, but im sitting with a new challenge now how do i add multiple groups of radio buttons ?

 

[GlennUK]

What kind of radio buttons do you have? Were they added from the Control Toolbox toolbar, or from the Forms toolbar?