calculate a grade point average

V

Vasant Nanavati

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.
 

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

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

Top