Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Hi, quick question about the following situation: So I have 4 yes/no radio buttons all in 4 different group boxes. I am trying to make it so that if I select yes for one of them, cell B2 populate "high", and if I select yes for two of them then B2 populate "medium", and if I select yes for none of them or for any 1 of 4, B2 populate "low". Which radio buttons selected are irrelevant, but it matters as to how many of them are selected. If I can get advice on how to code this that would be nice. Thanks.
Solved by O. H. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 01/12/2017 - 10:33
Hi
User 01/12/2017 - 10:33
hi!
User 01/12/2017 - 10:33
how are you
Excelchat Expert 01/12/2017 - 10:34
So so, so do you have a file to work on?
User 01/12/2017 - 10:35
um well yea but can u help me based on the description?
User 01/12/2017 - 10:35
cause the spreadsheet might be confusing
User 01/12/2017 - 10:35
I just need help on that area
Excelchat Expert 01/12/2017 - 10:35
I hope so
User 01/12/2017 - 10:35
it's like area by area
Excelchat Expert 01/12/2017 - 10:35
Ok let me check
User 01/12/2017 - 10:36
ok thanks!
User 01/12/2017 - 10:36
I know it might be bunch of if/else statement
User 01/12/2017 - 10:37
but I'm not surehow to assign the radio buttons in the if/else statement..
User 01/12/2017 - 10:39
do I have to assign an individual macro to each of the 4 radio buttons first so I get their macro names? and then use those macro names in the if/else statement for the whole ? not sure if that's possible..
Excelchat Expert 01/12/2017 - 10:39
May be so , let em try
User 01/12/2017 - 10:39
okok
User 01/12/2017 - 10:40
ok ok*
Excelchat Expert 01/12/2017 - 10:55
https://www.dropbox.com/s/c9docem8z1p6qj8/High_Low.xlsm?dl=0
Excelchat Expert 01/12/2017 - 10:56
So far this what I did, I ahve not assigned a code
User 01/12/2017 - 10:56
oh ok
Excelchat Expert 01/12/2017 - 10:56
And it is working on serieally, means if you select the first one
Excelchat Expert 01/12/2017 - 10:56
low will pop up
Excelchat Expert 01/12/2017 - 10:56
Second low
Excelchat Expert 01/12/2017 - 10:57
third High
User 01/12/2017 - 10:57
oh ok
User 01/12/2017 - 10:57
I mean there should be 8 buttons
User 01/12/2017 - 10:57
4 yes radio buttons
User 01/12/2017 - 10:57
4 no radio buttons
User 01/12/2017 - 10:57
and they come in couples
User 01/12/2017 - 10:57
so 4 group boxes
Excelchat Expert 01/12/2017 - 10:57
Ok
User 01/12/2017 - 10:57
each has a yes radio button and no radio button
User 01/12/2017 - 10:57
yea
Excelchat Expert 01/12/2017 - 10:58
So if A group has yes
Excelchat Expert 01/12/2017 - 10:58
Then low
User 01/12/2017 - 10:58
and if I select yes for any 2 of the 4 sets
User 01/12/2017 - 10:58
right
User 01/12/2017 - 10:58
or if all no
User 01/12/2017 - 10:58
then it's low
Excelchat Expert 01/12/2017 - 10:58
ok let me workout
User 01/12/2017 - 10:58
but if two of them are yes, any two, then medium
User 01/12/2017 - 10:58
ok thanks
User 01/12/2017 - 10:58
yea sry for the confusion
User 01/12/2017 - 10:58
if 3 of them are yes, any 3, then hihg
User 01/12/2017 - 10:58
high
User 01/12/2017 - 10:58
that's it
User 01/12/2017 - 10:59
oh sry not three
User 01/12/2017 - 10:59
oh yea three yea sry lol
User 01/12/2017 - 10:59
that's the situation
Excelchat Expert 01/12/2017 - 10:59
ok let me think and work
User 01/12/2017 - 11:01
sure
User 01/12/2017 - 11:01
thanks again
User 01/12/2017 - 11:32
everything ok my friend?

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.