Si la moyenne de l'étudiant se trouve en A1, laquelle de ces formules indique correctement la situation (recalé, passable ou mention) ?

Question

Accepted Answer

=SI(A1<10; "recalé"; SI(A1<12; "passable";"mention"))

Answer

=SI(A1<12 ; "passable"; si(A1<10 ;"recalé"; "mention"))

Answer

=SI(A1>12; "mention"; A1>10 ; "passable"; "recalé")

Answer

=SI(0;"recalé";10"passable";12;"mention")

Answer

=SI(A1<10; "recalé") et si(A1<12; "passable";"mention")

Crowdly