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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Mike in ITIT 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rrave26Author Commented:
Thanks this perfect.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.