| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 -- Ironwig ------------------------------------------------------------------------ Ironwig's Profile: http://www.excelforum.com/member.php...o&userid=33527 View this thread: http://www.excelforum.com/showthread...hreadid=533256 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pls help/ im begging? hehe
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pls help/ im begging? hehe
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pls help/ im begging? hehe
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pls help/ im begging? hehe
heere is the excel sheet -- Ironwig ------------------------------------------------------------------------ Ironwig's Profile: http://www.excelforum.com/member.php...o&userid=33527 View this thread: http://www.excelforum.com/showthread...hreadid=533256 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
pls help/ im begging? hehe
http://www.ironwig.com/book1.zip -- Ironwig ------------------------------------------------------------------------ Ironwig's Profile: http://www.excelforum.com/member.php...o&userid=33527 View this thread: http://www.excelforum.com/showthread...hreadid=533256 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
