+ Reply to Thread
Results 1 to 8 of 8

Giving a Letter Grade based off Cells

  1. #1
    Registered User
    Join Date
    03-13-2021
    Location
    Oakville
    MS-Off Ver
    16.46
    Posts
    4

    Giving a Letter Grade based off Cells

    I am currently working on a project and cannot figure out how to solve it. The project has me assigning a letter grade based off grades that a person will input in a cell. I have written code that I think will do the job but it will only display an "F" where it should be an "A" or a "B". Any feedback or suggestions would be greatly appreciated. Below is what my code currently looks like. I am not looking for someone to do the project for me but rather I am stuck on a step and am seeking help on a solution.

    EDIT
    Since the code looks weird and not formatted correctly I have attached an image which shows what the code actually looks like

    Please Login or Register  to view this content.
    Last edited by AliGW; 03-29-2021 at 01:21 PM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,755

    Re: Giving a Letter Grade based off Cells

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. As you are new here, I have done it for you today.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,755

    Re: Giving a Letter Grade based off Cells

    Do NOT remove edits that a moderator has made. You are REQUIRED to enclose code within code tags. I will add them again - LEAVE THEM ALONE this time, please.

    I have also removed the completely unnecessary image taking up so much room.

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,819

    Re: Giving a Letter Grade based off Cells

    I do not replicate the error. What is the value of Score when you get an incorrect result? My guess is that Score contains something other than the value you think it does, which is probably a bug in the calling procedure (not shown in your OP).

    Here's my test procedure
    Please Login or Register  to view this content.
    Last edited by MrShorty; 03-29-2021 at 01:39 PM.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,755

    Re: Giving a Letter Grade based off Cells

    It has been resolved by me - THREE TIMES now, and the OP keeps removing them.

    Please go ahead with the suggested solution.

  6. #6
    Registered User
    Join Date
    03-13-2021
    Location
    Oakville
    MS-Off Ver
    16.46
    Posts
    4

    Re: Giving a Letter Grade based off Cells

    I am sorry I am new to these forums and the rules behind them. I tried to take your suggestions/forum requirements and add them to my post but you have said I messed up and I will not change the post further. My apologies.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,755

    Re: Giving a Letter Grade based off Cells

    Thank you.

  8. #8
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,410

    Re: Giving a Letter Grade based off Cells

    Just noting that the function could also be written this way...
    Please Login or Register  to view this content.

+ 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. Creating a formula to make a letter grade based on another field
    By Tank1978 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-23-2016, 09:06 AM
  2. Figuring a letter grade based on a %
    By mkingsley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-15-2008, 01:05 PM
  3. Macro To Change Letter Grade To Number Grade
    By florinel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-29-2008, 11:14 PM
  4. Factoring a letter grade based on a percentage
    By mkingsley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-27-2006, 12:55 PM
  5. [SOLVED] Grade Percentage into letter grade
    By James in forum Excel General
    Replies: 4
    Last Post: 12-13-2005, 11:30 PM
  6. I am trying to set a letter grade for my students, HELP
    By UTI Rod in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. [SOLVED] I am trying to set a letter grade for my students, HELP
    By UTI Rod in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM

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