Hi for everyone
I'm new in the Excel world. I'm taking an Excel course, but is hard if you don't have the basics.

Please I need some help, not for resolving my homework, but to understand the mechanism. Of course, my file can be improved...

So, I need to insert an function (don't know which one... ) on the L column, witch will tell me if the student has passed or not.

The stages are:

• if has at least 1 score, or 2, or 3 under 5 it will be half passed
• if has at least 4 scores under 5, will fail
  else will pass

I've made a trick to show this stage on the L column, but I think is not correct.

Tks fo your help!

Attached Files

Book1.xlsx (15.4 KB, 10 views)