calculating risk

[Me]

Hi I use a paper form at work that asks 3 multiple choice questions. The
answer to each question is given a score, and the total score is then used
to calculate whether risk is low, medium, high or very high.

What I'd like to do is set this up in Excel 2002 so that the user simply
clicks to select their choice for each question, and the score then results
in the assessed risk level being printed on screen.

Can anyone please either give me an outline of how to do this, or point me
to where I can find a sample that I could modify.

My email address as shown in newsgroups is fictitious. But I can display a
little used address if anyone is able to send me a sample.

Many thanks

 

[CLR]

I see this as being a bit of a "project", and probably more than you can get
a one-time set of instructions for here. I would recommend you set up
Validation Boxes for your multiple choice questions, and then use VLOOKUP
functions to return values for each selected answer, and then a formula
and/or another VLOOKUP function to determine the "risk". If you run into
problems, then post back here with the details.

hth
Vaya con Dios,
Chuck, CABGx3

 

[Max]

Please do not multi-post

One suggestion given in
excel.worksheet.function

: http://tinyurl.com/3586n