Question description:
This user has given permission to use the problem statement for this
blog.
Can you help me to create a nested if formula, that will identify for the grade result of the corresponding Average Score?
Solved by C. A. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
13/05/2018 - 11:54
Hello
Excelchat Expert
13/05/2018 - 11:55
Do you have a sample excel sheet that corresponds with your question?
Excelchat Expert
13/05/2018 - 11:55
I want to make sure I understand your question before we go on
Excelchat Expert
13/05/2018 - 11:59
So since I have not received a response from you, let me come up with a sheet that I think will correspond to the answer you are looking for
Excelchat Expert
14/05/2018 - 12:09
So I have created the nested if statement on Column B
Excelchat Expert
14/05/2018 - 12:09
The average score can be found on B2
Excelchat Expert
14/05/2018 - 12:09
we are currently comparing against this average in the nested if statement
Excelchat Expert
14/05/2018 - 12:10
the explanation for each grade can be found on table D1:F4
Excelchat Expert
14/05/2018 - 12:10
where each letter grade corresponds to different grades based on teh average test score
Excelchat Expert
14/05/2018 - 12:10
Hope this answer helps and good luck!
Excelchat Expert
14/05/2018 - 12:10
Thanks for visiting the site and I wish you had not disconnected
Excelchat Expert
14/05/2018 - 12:12
I have also modified the cell B1 to be an average found from the test results found in Column A starting at A6 and going down
Excelchat Expert
14/05/2018 - 12:12
As a bonus feature
Excelchat Expert
14/05/2018 - 12:12
Thanks!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
