+ Reply to Thread
Results 1 to 2 of 2

Grade Point Calculator

  1. #1
    Registered User
    Join Date
    06-15-2012
    Location
    Columbus
    MS-Off Ver
    Excel 2010
    Posts
    1

    Grade Point Calculator

    I am trying to get Excel to calculate my Grade Point Average. I have a sheet set up with my grades set up. Right now, I have to put in the grade and then put in what Grade Point that it translates to. I am fine with putting in the grade but I would like Excel to determine what the Grade Point is based on what grade was input. I imagine that IF statements would help me with this, but all that I can think of is making something like =IF(A1>91, "4.0"), but that would only make 4.0s work.

    I couldn't get the table to copy and paste nicely, but the website with the Grade Point information is https://sites.google.com/site/glhscourses/
    Scroll to the bottom for the Grade Point Table.

    Update: I tried =IF(J3>91, 4.0," IF(J3>89, 3.7, IF(J3>87, 3.3, IF(J3>81, 3.0, IF(J3>79, 2.7, IF(J3>77, 2,3, IF(J3>71, 2.0, IF(J3>69, 1.7, IF(J3>67, 1.3, IF(J3>61, 1.0, IF(J3>59, 0.7, 0))))))), and it gave me an error unrelated to parenthesis. I have too many arguments.
    Last edited by hgpot; 06-15-2012 at 04:38 PM. Reason: Further trial and error.

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Grade Point Calculator

    Duplicate the table in your sheet and use VLOOKUP() function to retrieve the values from the table.

    here is a link to read about the use of the function: http://www.excelfunctions.net/ExcelVlookup.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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