V
Victoria612
I have 6 questions that may be answered yes or no, and for the sake of
keeping everything in integer form, let's assume "1" for yes and "0" for no.
Depending on how a customer answers all 6 questions, they will receive a
predetermined score. I am attempting to develop the answer key, so-to-speak,
to refer the reps to once they are finished asking the customer these
questions.
I was hoping for the code that would build a macro to create this tabe for
me - a table that would lay out all of the 6 question-answer combinations,
like the following:
Questions Scenario 1 Scenario 2 Scenario 3 Scenario 4
1 1 1 1
1
2 1 0 0
0
3 1 1 0
1
4 1 1 1
0
5 1 1 1
1
6 1 1 1
1
....and so on, so that I am given all the possible 6 answer scenarios....
Your help is greatly appreciated!
Victoria
keeping everything in integer form, let's assume "1" for yes and "0" for no.
Depending on how a customer answers all 6 questions, they will receive a
predetermined score. I am attempting to develop the answer key, so-to-speak,
to refer the reps to once they are finished asking the customer these
questions.
I was hoping for the code that would build a macro to create this tabe for
me - a table that would lay out all of the 6 question-answer combinations,
like the following:
Questions Scenario 1 Scenario 2 Scenario 3 Scenario 4
1 1 1 1
1
2 1 0 0
0
3 1 1 0
1
4 1 1 1
0
5 1 1 1
1
6 1 1 1
1
....and so on, so that I am given all the possible 6 answer scenarios....
Your help is greatly appreciated!
Victoria