ardykav

Board Regular
Joined
Oct 18, 2015
Messages
160
I have a question sheet which asks 4 basic questions. Then depending on the answers it gives the person a score.

For Questions 1-3 the answer is a straight yes or no, then for question 4 the answer is Yes, no, maybe, not sure.

What i want is a list of all combinations of answers so i can then add a score to each.

Is there a quick way of doing this?
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,350
What's the difference between "Maybe" and "Not Sure"?
It's the same thing surely?

Would you ever rob a bank?
a) Yes
b) No
c) Maybe
d) Not Sure

c) and d) are the same

Or are you saying Maybe is more than Yes than No?
Your descriptions are very confusing. I have never seen answers with both Maybe and Not Sure.
I hope you define these description of those answers clearly to the user or you'll be getting incorrect responses.

You'd do better to have a sliding scale from 1 to 10 with 1 being No and 10 being Yes.
 
Last edited:

ardykav

Board Regular
Joined
Oct 18, 2015
Messages
160
Apologies having reread the options are confusing however I hadnt given the actual options for a couple of reasons, I have manually worked it out anyhow but thanks for your responses and Yes I am not sure if I would maybe rob a bank!!

What's the difference between "Maybe" and "Not Sure"?
It's the same thing surely?

Would you ever rob a bank?
a) Yes
b) No
c) Maybe
d) Not Sure

c) and d) are the same

Or are you saying Maybe is more than Yes than No?
Your descriptions are very confusing. I have never seen answers with both Maybe and Not Sure.
I hope you define these description of those answers clearly to the user or you'll be getting incorrect responses.

You'd do better to have a sliding scale from 1 to 10 with 1 being No and 10 being Yes.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,383
Messages
5,624,375
Members
416,025
Latest member
VN5968

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
Top