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