Howdy doody Excelers,
I have been struggling all morning with what I assume is a simple problem to some of you. Everyday I have quizzes prepared, and the length of quizzes often changes. I am trying to create a spreadsheet which can automatically calculate score, given the total # of questions (variable), and the number of incorrect answers.
Specifically, I have
-A column for question # (A:A).
-On the right hand side, I have a column of questions (hidden).
-Column B is for when a student answers incorrectly, I note "Incorrect."
-Columns C and D indicate either -1 for incorrect, or +1 for correct, using a simple IF function. Columns E-F
Question:
Can anyone think of a function to determine the Correct/Total score, as displayed in E-G? Remember, the quiz lengths change on a daily basis. You may begin writing your answers...NOW! ;D
Garth
Table:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<tbody>
</tbody>
I have been struggling all morning with what I assume is a simple problem to some of you. Everyday I have quizzes prepared, and the length of quizzes often changes. I am trying to create a spreadsheet which can automatically calculate score, given the total # of questions (variable), and the number of incorrect answers.
Specifically, I have
-A column for question # (A:A).
-On the right hand side, I have a column of questions (hidden).
-Column B is for when a student answers incorrectly, I note "Incorrect."
-Columns C and D indicate either -1 for incorrect, or +1 for correct, using a simple IF function. Columns E-F
Question:
Can anyone think of a function to determine the Correct/Total score, as displayed in E-G? Remember, the quiz lengths change on a daily basis. You may begin writing your answers...NOW! ;D
Garth
Table:
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
A | B | C | D | E | F | G |
Question # | Note | Incorrect | Correct | |||
57 | incorrect | -1 | ||||
58 | +1 | |||||
59 | +1 | |||||
correct | total | score | ||||
56 | 59 | 95% | ||||
1 | +1 | |||||
2 | +1 | |||||
3 | incorrect | -1 | ||||
4 | +1 | |||||
5 | incorrect | -1 | ||||
6 | +1 | |||||
7 | +1 | |||||
8 | incorrect | -1 | ||||
9 | +1 | |||||
10 | +1 | |||||
11 | +1 | |||||
12 | +1 | |||||
correct | total | score | ||||
9 | 12 | 75% | ||||
1 | incorrect | -1 | ||||
2 | +1 | |||||
3 | +1 | |||||
correct | total | score | ||||
2 | 3 | 67% |
<tbody>
</tbody>