problem with a function to calculate weighted test score
 

OK, I am at a dead-end coming up with a formula for raw scores on student's
tests. I want to create a formula that takes two values:

A-test grade on m/c questions
B-test grade on a short answer question

A has to be 60% of the grade, B has to be 40% of the grade. A raw score
above 75 points is 100%

I have (so far):

=sum(A+B)/75 and that returns a value that is close to what I am looking
for. However, I now need to make A 60% of the grade and B 40% of the grade. I
am hoping I am tired, but I am just staring at the screen. Thanks in advance
for any help. If it is really simple answer, I am going to bang my head on
the desk. Thanks-Drew

problem with a function to calculate weighted test score
 

You mean
=(A1*60%)+(B1*40%)

If this post helps click Yes
---------------
Jacob Skaria


"Drew P." wrote:

OK, I am at a dead-end coming up with a formula for raw scores on student's
tests. I want to create a formula that takes two values:

A-test grade on m/c questions
B-test grade on a short answer question

A has to be 60% of the grade, B has to be 40% of the grade. A raw score
above 75 points is 100%

I have (so far):

=sum(A+B)/75 and that returns a value that is close to what I am looking
for. However, I now need to make A 60% of the grade and B 40% of the grade. I
am hoping I am tired, but I am just staring at the screen. Thanks in advance
for any help. If it is really simple answer, I am going to bang my head on
the desk. Thanks-Drew

problem with a function to calculate weighted test score
 

Then I was right, sort of; it has now come to me. We had that part, but the
number was not coming out. I realize that the error was in the next
calculation. We were looking for 75% right on the original grade to be our
score. It had to be 75% of the results from the formula below. Thank you for
your help. I have banged my head on the desk...

"Jacob Skaria" wrote:

You mean
=(A1*60%)+(B1*40%)

If this post helps click Yes
---------------
Jacob Skaria


"Drew P." wrote:

OK, I am at a dead-end coming up with a formula for raw scores on student's
tests. I want to create a formula that takes two values:

A-test grade on m/c questions
B-test grade on a short answer question

A has to be 60% of the grade, B has to be 40% of the grade. A raw score
above 75 points is 100%

I have (so far):

=sum(A+B)/75 and that returns a value that is close to what I am looking
for. However, I now need to make A 60% of the grade and B 40% of the grade. I
am hoping I am tired, but I am just staring at the screen. Thanks in advance
for any help. If it is really simple answer, I am going to bang my head on
the desk. Thanks-Drew