This one is easy. In column C type =A1*0.4+B1*0.6. Copy the formula down
for the rest of your students.

"UCLAN1" wrote:

I have got two columns A & B with a grade under each. Column A's grade 55
is worth 40% of the overall mark, and Column B's grade 50 is worth 60% of the
overall mark. What formula do I need to input in column C to automatically
do the calculation.

A B C
40% 60% Total

55 50

I would apperciate any assitance.