calculating formulas in excel
 

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.

calculating formulas in excel
 

Here are two ways:

=SUMPRODUCT(A1:B1,A2:B2)
or
=(A1*A2)+(B1*B2)


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"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.

calculating formulas in excel
 

If you want to copy this down column C, you will need to make it:

=(A$1*A2)+(B$1*B2)

Enter this into C2 and copy down for as many rows as you have data.

Pete

calculating formulas in excel
 

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.