View original (French)

The mention with the function =If

Allalou10 Posted messages 1 Status Membre -  
tuxboy Posted messages 1083 Status Membre -
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 réponses

Réponse 1 / 2
Gyrus Posted messages 3360 Status Membre 526
 
Hello,

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

Later!
0