Excel - IF Function Problem - Expert Solution

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
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

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc