I need help

[Ironwig]

could some one please help ? i have created a workbook that i want to use for a test system. treat it like a survey and have dropdows that they pik the answer, and it picks from 1-4 depending on their choice, and its put on the results worksheet. Then i have a "correct or not?" row that has eihter TRUE or FALSE if the student picked the correct answer according to the answer key (another worksheet)
i want to try and figure out a way that if i make up a 100 questions and i use this method of having true or false, how can i calculate how manye false vs true are there and get a percentage?
so if the miseed 4 questions (4 false) then the result is 96%

i am new to this excel world, but im trying to learn, if there is a eaier way to do this, please advise. thanks in advance...

Ironwig

[Delordson Kallon]

Use the COUNTIF function to count the number of occurences of False then
divide by the total number of questions and format as a percentage.

Thanks
Delordson Kallon
http://www.instantsoftwaretraining.com

"Ironwig" wrote:

>
> could some one please help ? i have created a workbook that i want to
> use for a test system. treat it like a survey and have dropdows that
> they pik the answer, and it picks from 1-4 depending on their choice,
> and its put on the results worksheet. Then i have a "correct or not?"
> row that has eihter TRUE or FALSE if the student picked the correct
> answer according to the answer key (another worksheet)
> i want to try and figure out a way that if i make up a 100 questions
> and i use this method of having true or false, how can i calculate how
> manye false vs true are there and get a percentage?
> so if the miseed 4 questions (4 false) then the result is 96%
>
> i am new to this excel world, but im trying to learn, if there is a
> eaier way to do this, please advise. thanks in advance...
>
> Ironwig
>
>
> --
> Ironwig
> ------------------------------------------------------------------------
> Ironwig's Profile: http://www.excelforum.com/member.php...o&userid=33527
> View this thread: http://www.excelforum.com/showthread...hreadid=533207
>
>

[davesexcel]

If you want to learn how to make drop down lists check out these sites

here's a little video to learn datavalidation,

http://www.datapigtechnologies.com/f...alidation.html

and here is a site to read about data validation and drop down lists

http://www.contextures.com/xlDataVal01.html

you could then have an if statement such as
=If(A1="the correct answer",1,0)

this will input the value of 1, if the answer is correct

then total the scores and get a percentage