IF formula to calculate your baccalaureate grade
Solved
Quingley
Posted messages
1168
Status
Membre
-
EricManDor -
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
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
In the end, I didn't need to use the intervals as I had anticipated.
Thank you very much for your help.
I really needed this formula. Thank you very much.