I am having trouble with the IF function in the example below.
- There are 3 exams and one total score.
- The student has to score at least 5 points in each exams to pass.
- If he has in one of the exams a score of 4 or less points he fails.
- However, the total score has to be >=16 to pass, otherwise he also fails.
Test 1 = 4, Test 2 = 10, Test 3 = 10, Total = 24; he has more than 16 but fails because he got a 4 in one of the exams.
Test 1 = 5, Test 2 = 5, Test 3 = 5, Total =15; fails again because the total score is under 16.
I used this function:
It works fine except in the scenario where the student gets a 4 or less in one of the exams. When this happens, I get
FALSE but I want it to be