Results 1 to 8 of 8

Giving a Letter Grade based off Cells

Threaded View

  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

    Sub Button29_Click()
    Public Function GetLetterGrade(Score As Double) As String
    Select Case Score
        Case Is < 0.5
            GetLetterGrade = "F"
        Case Is < 0.6
            GetLetterGrade = "D"
        Case Is < 0.7
            GetLetterGrade = "C"
        Case Is < 0.85
            GetLetterGrade = "B"
        Case Else
            GetLetterGrade "A"
    
    
    End Select
    
    End Function
    Last edited by AliGW; 03-29-2021 at 01:21 PM.

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