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