calculate a grade point average

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I set up Microsoft Excel to calculate a Grade Point Average??
 
If the course names are in column A, the credit-hours in column B and the
letter grades in column C, try:

=SUMPRODUCT((B1:B5)*((69-CODE(LEFT(C1:C5,1))+(LEFT(C1:C5,1)="F"))+((RIGHT(C1
:C5,1)="+")-(RIGHT(C1:C5,1)="-"))/3))/SUM(B1:B5)

assuming the grades are A, B, C, D and F with pluses and minuses.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculating average handling time 7
Omit empty cells? 0
lookup formula not picking up correct data 2
Weighted grades 2
Counting multiple memberships 1
Grades in Excell 2007 1
Average last 3 in range 13
IF function 4

Back
Top