Sign in to follow this  
Followers 0

Calculate Grades in Excel 2007

3 posts in this topic

Posted

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

Share this post


Link to post
Share on other sites

Posted

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.