Help needed with radiobutton and "IF" function

andre4dee

New Member
Joined
Oct 21, 2005
Messages
21
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
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
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?
 
Upvote 0
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
 
Upvote 0
You say the radio buttons are 'in' the cells?

But are they actually linked to the cells?
 
Upvote 0
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 ?
 
Upvote 0
What kind of radio buttons do you have? Were they added from the Control Toolbox toolbar, or from the Forms toolbar?
 
Upvote 0

Forum statistics

Threads
1,217,508
Messages
6,137,036
Members
450,041
Latest member
MM2024

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top