GPA Calculator

Please Login or Register  to view this content.

Ok so basically this code is supposed to figure out if the said cell is less then 5 to equal what it is, and if it is 5 to equal 0 (it's 5 when you don't have that class). The problem is that it doesn't recognize when my cells equal 5. so basically it just always equals the cell.

How would you suggest fixing this? I zipped it and attached it.

All you need to do is take the quotes out of the equation, so excel doesn't think you are passing a string.

Should look like this:

=(IF(C2<5,C2,0)+IF(C3<5,C3,0)+IF(C4<5,C4,0)+IF(C5<5,C5,0)+IF(C6<5,C6,0)+IF(C7<5,C7,0)+IF(C8<=4,C8,0)+IF(C9<5,C9,0))/E10

You ought to remove quotes from C2:C9 formulas, as the results of these will also be interpreted as text, i.e. change C2 to

=IF(B2="A",4,IF(B2="A-",3.667,IF(B2="B+",3.333,IF(B2="B",3,IF(B2="B-",2.667,IF(B2="C+",2.333,IF(B2="C",2,IF(B2="C-",1.667,D2))))))))

copied down to C9

then in C11

=SUMIF(C2:C9,"<5")/E10

If you want to avoid having nested IFs spread over two columns you could get column C scores more easily with a two column table (grades in one column, score for that grade in the next) and a simple VLOOKUP formula