Jump to content



Photo

Calculate Grades in Excel 2007


  • Please log in to reply
2 replies to this topic

#1 YouAgain87

YouAgain87

    Neowinian

  • Joined: 21-July 08
  • Location: London, UK

Posted 09 December 2010 - 10:32

Hi guys, I would appreciate if I could get some help with excel 2007. I need to design a spreadsheet which is used to calculate student grades. So say column A would have a range of numbers between 0 and 100 representing a mark achieved by a student. I would like to find a way to use a formula so that it is able to show a grade in Column B.

So for example is for someone achieves a 53 that would be a D.

Of course I’d like it so I could specify data ranges i.e anyone achieving a mark between say 40 and 55 would be recognised as having achieved a D and have that placed in column b by their mark.

Any help really appreciated.


#2 Johnston

Johnston

    Johnston

  • Joined: 11-May 04
  • Location: Northern Ireland

Posted 09 December 2010 - 10:48

=IF(A1>70,"A",IF(A1>60,"B",IF(A1>50,"C",IF(A1>40,"D","FAIL"))))

#3 c.grz

c.grz

    Neowinian

  • Joined: 22-September 04
  • Location: Chicago, Illinois
  • OS: Windows 8 Professional
  • Phone: Nokia Lumia 925

Posted 12 December 2010 - 13:46

http://excel.tips.ne...ter_Grades.html



Click here to login or here to register to remove this ad, it's free!