Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() 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 |