Grade Spreedsheet

[FluidicAztec]

Hi,

So I'm doing a basic grade to GPA spreadsheet. Column I has the letter grade that is picked from a drop down list that references a simple named list on another worksheet. Column J has the following:

=IF(I2="A","4",IF(I2="B","3",IF(I2="C","2",IF(I2="D","1",IF(I2="F","0",IF(I2="",""))))))

I then have J16 do this:

=SUM(J2:J15)

The problem is J16 only returns 0. Also, how would I have J16 sum then divide the result by the number of cells that have a value in J2:J16 ?

Thanks in advance

[mrice]

try

=INT(IF(I2="A","4",IF(I2="B","3",IF(I2="C","2",IF(I2="D","1",IF(I2="F","0",IF(I2="","")))))))

Your version retuned a string rather than a number.

Alternatively

=IF(I2="A",4,IF(I2="B",3,IF(I2="C",2,IF(I2="D",1,IF(I2="F",0,IF(I2="",""))))))

which returns numbers directly.

[FluidicAztec]

mrice...awesome, I tried the second option and it worked. I didn't realize that the quotes turned the numbers into characters.

[AlKey]

Or try this one

=IF(I2="","",LOOKUP(I2,{"A","B","C","D","F"},{4,3,2,1,0}))

[acroley1]

Also at the end of your equation you could add +0 and that would turn your # back into a #.