Saturday, November 11, 2017

yogi_Compute GPA Based On Marks For Tests Taken In AP and Non-AP Classes

Google Spreadsheet   Post  #2279

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-11-2017
question by: Principal Derek
https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!topic/docs/zbRdM5VVfZM;context-place=forum/docs

Trying to make a GPA tracker and struggling with IFERROR
I am trying to set up a GPA tracker for the school I work at. Here is the file I am working with.

My problem is that kids may or may not take certain courses, but the empty cells are averaging in as zeros. Also, the GPAs are weighted with A+, A, A- etc. And the AP classes are out of 5 grade points where the non-AP classes are out of 4. 

How do I get this to work? 

No comments:

Post a Comment