M
mitchbragg
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
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