CALCULATE WITH AVERAGE ????

[rlashmore999]

I need a formula to calculate students marks using the average
command. It goes as follows and I haven't got a clue and I havent got
a clue

Use the AVERAGE function to compute the average mark for cells B2,
C2, D2 and the examination.

Insert new columns Total (assignments), Total (overall).

Compute the weighted average assignment mark for each student as a
percentage,
according to the following formula:

Cell E2 is Total (assignments) = B2*5/40 + C2*20/40 + D2*15/40

Marks are : B2 = marks out of 5
C2 = marks out of 20
D2 = marks out of 15

They will represent 40% of the total mark.



I tried this

AVERAGE= (B2/5*100)+(C3/20*100)+(D2/15*100)

It said Locate cells that create a circular reference.
The one note I've got swears the (B2/5*100) is right.

Then next

17. Compute the overall total mark for each student, according to the
following formula:
Total (overall) = min(A +10, E + 10, 0.4A + 0.6E)
where A is each student's total assignment mark expressed as a
percentage, and E is each student's exam mark expressed as a
percentage.
Cells are :

 

[Sandy Mann]

This is the third time that you have posted exactly the same post and it
still sound like homework to me.

Additionally the request as posted does not make sense, (at least to me)

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk