I have been given a task in Excel and am struggling to come up with a
formula. Can anyone help?

Calculate the average grades for the students.
Using the average grade create an IF statement to generate a target grade
based on the criteria below.

Note: this will require the use of AND and OR

A - Average 60+; English AND Maths 70+.
B - Average 60+; English, Maths OR Science 70+
C - Average 60+
D - Average between 40-60; English, Maths AND Science 50+
E - other

Use conditional formatting to highlight those grades below C