If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
calculating risk
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 |
#2
|
|||
|
|||
calculating risk
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 "Me" wrote in message ... 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 |
#3
|
|||
|
|||
calculating risk
Please do not multi-post
One suggestion given in excel.worksheet.function : http://tinyurl.com/3586n -- Rgds Max xl 97 --- Please respond, in newsgroup xdemechanik atyahoodotcom ---- |
Thread Tools | |
Display Modes | |
|
|