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 :