pls help/ im begging? hehe

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

If ALL your TRUE/FALSE answers are in a SINGLE row then assuming data is in
row 10:

Put this in required cell and format as %

=COUNTIF(10:10,False)/100 will give % False

=COUNTIF(10:10,True)/100 ) will give % True



"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=533256
>
>

that didint work for me
the tru and false are on row 6
so i put =COUNTIF(6:6,TRUE)/100
and format to percent
it just stay at 0%
also, how would o go about creating a submit button that when pressed will save all the answered chosen and save them on the results page, then clear the question sheetfor the next person to take the test? so everytime they put a new name and hit save, it wills ave results on same workbook?
i can attach it if you want to better see what i am talking about
thanks a million

Yes .. it would help if you can post a sample file.

"Ironwig" wrote:

>
> that didint work for me
> the tru and false are on row 6
> so i put =COUNTIF(6:6,TRUE)/100
> and format to percent
> it just stay at 0%
> also, how would o go about creating a submit button that when pressed
> will save all the answered chosen and save them on the results page,
> then clear the question sheetfor the next person to take the test? so
> everytime they put a new name and hit save, it wills ave results on
> same workbook?
> i can attach it if you want to better see what i am talking about
> thanks a million
>
>
> --
> Ironwig
> ------------------------------------------------------------------------
> Ironwig's Profile: http://www.excelforum.com/member.php...o&userid=33527
> View this thread: http://www.excelforum.com/showthread...hreadid=533256
>
>

heere is the excel sheet

http://www.ironwig.com/book1.zip