Score calculator based on the various combination of answers.

I need some help creating a score predictor based on the selection of certain options.  I am working on a change risk score calculator that will provide me a risk score calculator based on a users selection of the various options.  The score will be used to provide risk ranges.  I have attached the spreadsheet I started, Column A shows the area being evaluated, column B is the questions for each area and column C is the score that has been assigned to each answer.

What I want to see is each over score based on the variations of the options selected in a spreadsheet layout so I can evaluate the score breakdowns.
Score-Calculator.xlsx
Rrave26Asked:
Who is Participating?
 
Mike in ITConnect With a Mentor IT System AdministratorCommented:
I have added a sheet that has all the different possibilities to it.

I'm not sure if that is what you are looking for.
Score-Calculator.xlsx
0
 
Rrave26Author Commented:
You are exactly correct.  I am completely aware of all of the possibilities that is why I reached out here.  to answer your question about limiting answers or selection the answer is no.  All of the options are still available if you  change one of your answers.
0
 
Rrave26Author Commented:
There is no scorecard unfortunately, that is what I am trying to build.  Then I can show ranges to group these values into which will drive risk and impact ratings.
0
 
Rrave26Author Commented:
Thanks this perfect.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.