calculating formulas in excel

[Guest]

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.

 

[Guest]

Here are two ways:

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


Does that help?

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

XL2002, WinXP-Pro

 

[Pete]

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

 

[Guest]

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