# Possibility Matrix

#### ardykav

##### Board Regular
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?

### 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
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:

#### MrIfOnly

##### Active Member
Maybe I would rob a bank, Not Sure I would tell you though.

#### ardykav

##### Board Regular
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.

Replies
4
Views
119
Replies
5
Views
218
Replies
2
Views
94
Replies
8
Views
162
Replies
2
Views
505

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.

### Which adblocker are you using?

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

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