View original (French)

The mention with the function =If

Allalou10 Posted messages 1 Status Member -  
tuxboy Posted messages 1083 Status Member -
Hello everyone
Please, I have a case with the function (=IF), and I need to give the following mentions depending on the students' grades! For example: =IF(G5<10, IF(G5>12,"passable"!
And what I know as a beginner is that with this function I can look for two mentions at most, and I need to find 4 mentions: passable, fairly good, good, and very good!
Can you help me? Thanks in advance!

2 answers

  1.
    Gyrus Posted messages 3360 Status Member 526
     
    Hello,

    You can nest the IF functions 
    =IF(G5>8,IF(G5>12,IF(G5>16,"Very good","Good"),"Fair"),"Passable")

    Later!
    0