software

I have got two columns A amp; 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.

Here are two ways:

=SUMPRODUCT(A1:B1,A2:B2)
or
=(A1*A2) (B1*B2)Does that help?

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

XL2002, WinXP-Proquot;UCLAN1quot; wrote:

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

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.

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

quot;UCLAN1quot; wrote:

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