+ Reply to Thread
Results 1 to 2 of 2

How do I assign numerical values to a letter? Ex: A = 4, B=3, etc

  1. #1
    Bob1023
    Guest

    How do I assign numerical values to a letter? Ex: A = 4, B=3, etc

    I'm trying to do a spreadsheet function where I need to assign numerical
    values to a letter. Like calculating your collge GPA. A = 4, B=3, C=2, D=1,
    F=0. Can I do that?

  2. #2
    Greg Wilson
    Guest

    RE: How do I assign numerical values to a letter? Ex: A = 4, B=3, etc

    For example, paste this to any cell except A1 and enter letter grades in A1:

    =VLOOKUP(A1,
    {"A+",4.5;"A",4;"B+",3.5;"B",3;"C+",2.5;"C",2;"C-",1.5;"D",1;"F",0}, 2, 0)

    Regards,
    Greg

    "Bob1023" wrote:

    > I'm trying to do a spreadsheet function where I need to assign numerical
    > values to a letter. Like calculating your collge GPA. A = 4, B=3, C=2, D=1,
    > F=0. Can I do that?


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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