# How to work out the average grade (letters A-D) with a formula?

1. ## How to work out the average grade (letters A-D) with a formula?

I've been searching a few different threads, and I've tried all the solutions posted but nothing seems to work.

So far the main answer for this question seems to be something like this: '=IF(Average(1, "A", IF(Average(2, "B", IF(Average(3, "C", IF(Average(4, "D", "Fail")))))))) - but this doesn't work.

I'm very new to formulas, I'm just trying to teach myself some new things to make working a bit more efficient.

Any help much appreciated.  Register To Reply

2. ## Re: How to work out the average grade (letters A-D) with a formula?

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Do not try to use the Paperclip icon, as this does not work on this forum.  Register To Reply

3. ## Re: How to work out the average grade (letters A-D) with a formula?

You have to transcribe it correctly

=IF(Average=1,"A",IF(Average=2,"B", IF(Average=3,"C", IF(Average=4,"D","Fail"))))  Register To Reply

4. ## Re: How to work out the average grade (letters A-D) with a formula? Originally Posted by PhilEvans So far the main answer for this question seems to be something like this: '=IF(Average(1, "A", IF(Average(2, "B", IF(Average(3, "C", IF(Average(4, "D", "Fail")))))))) - but this doesn't work.

I'm very new to formulas,
What is AVERAGE in your formula? Is it a Defined Name for a cell? If so, then Bob's suggestion should work for you. However, given you are new to formulas, I am thinking you do not know what a Defined Name is yet, so my guess it is not that. More likely is it was your attempt to use the AVERAGE function. The AVERAGE function needs a range of cells given to it so that it can calculate the average for the values in the specified cells. We can give you a formula using the AVERAGE function correctly, but you need to tell us two things... one, what columns (or possibly rows depending on how your data is laid out) are you averaging (tell us the full range dedicated to the student scores even if no test values are in them yet)... two, because averages usually involve fractional values (averages are usually not whole numbers), what is the span of scores for each letter grade? On that last point, we need to know that, say, a B score could be any number from 1.5 to 2.5 (you give us the actual range of values for each letter grade)... and make sure you tell us which grade the end points belong to (for example, is 2.5 a B or a C)?  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 