Hello All,
The following formula returns the correct value of 80% = IF(F37=0%,"",SUM(F37:F43)/COUNTIF(F37:F43,">50%"))
But pulls the incorrect value of C+ from this formula =VLOOKUP(F36,'Grading Scale'!$E$5:$F$17,2,TRUE)
C+ = 78% whereas B- = 81%. As you can see 80% is closer to 81% than 78% and therefore should return a grade of B- not C+
Thank you,
Patrick
Bookmarks