+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    08-25-2019
    Location
    Wales
    MS-Off Ver
    Office 365
    Posts
    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.

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    636

    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.

  3. #3
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,225

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

  4. #4
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,395

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

    Quote Originally Posted by PhilEvans View Post
    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)?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Please, please Help. Average grade formula
    By kevwilsondj in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-09-2014, 02:17 PM
  2. [SOLVED] Formula in macro dont work with mixed number and letters
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-22-2014, 10:37 AM
  3. Need Average Formula for Letters
    By kxkxkxx in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-02-2014, 01:26 PM
  4. [SOLVED] Grade average formula
    By deepanc in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-06-2014, 12:42 AM
  5. Replies: 8
    Last Post: 06-07-2012, 09:14 AM
  6. Grade point average using AVERAGE, IF, AND, is not doing what I want
    By smurfnibblin in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-07-2006, 03:47 AM
  7. [SOLVED] Grade book average formula
    By Will in SF in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-23-2005, 05:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1