Thread: Figuring Grades
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mkingsley
 
Posts: n/a
Default Figuring Grades


I have a worksheet that has the data for all of my students labs and
tests.
Two summation formulas, one for the total points available, and one for
the students results. The final formula calculates a percentage (90%,
80%, et)
What I want to do is write an IF formula that looks to see what the
percentage the student has, and then return a letter grade.

Example

NAME POINTS % LETTER GRADE
Mike Kingsley 656 92.3% (its in this cell that the
formula would be written, and the grade would appear)

As Always thanx for the help

MK


--
mkingsley
------------------------------------------------------------------------
mkingsley's Profile: http://www.excelforum.com/member.php...fo&userid=4291
View this thread: http://www.excelforum.com/showthread...hreadid=530198