View original (French)

IF formula to calculate your baccalaureate grade

Solved
Quingley Posted messages 1168 Status Member -  
 EricManDor -
Hello,

As I'm in my final year this year, I'm preparing for my baccalaureate. Since I have mock exams next week, I need to use Excel 2007 to calculate the average and the grade I could have obtained if I were taking my baccalaureate right now.

To calculate a grade, I need to use the IF function in Excel, which I don't fully master yet. In fact, the problem is that I don't know how to include ranges in this formula.

Since I have no one on hand to ask for help, could you please let me know what Excel formula to enter so that it displays a grade on the screen based on the average obtained?

Moreover, to simplify things for you, I just found this website. I also need to let you know that the IF function must take into account that I might fail or have to take a retake oral exam.

Thank you in advance for your help.

Configuration: Windows 7 / Internet Explorer 10.0

2 answers

  1.
    _guigui_ Posted messages 603 Status Member 209
     
    Hello,
    let's suppose your average is in G6,
    Then in G7 you type:
    =IF(G6<8,"FAILED",IF(G6<10,"COMPENSATION",IF(G6<12,"ADMITTED WITHOUT HONORS",IF(G6<14,"HONORS",IF(G6<16,"GOOD","VERY GOOD")))))
    50
    1. Quingley Posted messages 1168 Status Member 709
       
      Your solution works.
      In the end, I didn't need to use the intervals as I had anticipated.
      Thank you very much for your help.
      0
    2. jsuisinteligent
       
      cte darr
      0
    3. EricManDor
       

      I really needed this formula. Thank you very much.

      0