Thread: I'm a noob
View Single Post
 
Old 10-25-2022, 08:53 AM
darian@ darian@ is offline Windows 11 Office 2021
Novice
 
Join Date: Oct 2022
Location: Romania
Posts: 2
darian@ is on a distinguished road
Default I'm a noob

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
File Type: xlsx Book1.xlsx (15.4 KB, 10 views)

Last edited by darian@; 10-25-2022 at 08:56 AM. Reason: attach file
Reply With Quote