I am trying to have a column that will tell me if a student has passed, they can only pass if they get a 60% score for each section, there are four sections.

eg; Cell A1 has a score out of 30 so pass mark is 18
Cell B1 has a score out of 35 so pass mark is 21
Cell C1 has a score out of 35 so pass mark is 21
Cell D1 is marked as Pass or Not Pass

so to get a overall pass the student will need to get at least the minimum score
for each test. As I have over 400 results it would be great if the final score could be calculated for me if possible in excel.