Newbies Doug Mohr Posted January 20, 2001 Newbies Share Posted January 20, 2001 Can anyone provide me some assistance regarding how to write a calculation to determine a letter grade. Each of my students has a course percentage. Based on each students percentage I would like to calculate whether their grade is A+, A, A-, etc. Thanks in advance for assistance with how to do this. Link to comment Share on other sites More sharing options...
LiveOak Posted January 20, 2001 Share Posted January 20, 2001 Grade (calculation, text) = Case( Score >= 95, "A+", Score >= 90, "A", Score >= 80, "B", Score >= 70, "C", Score >= 60, "D", "F") Evaluations are performed in order. If the Nth test succeeds, the Nth + 1 test is not performed -bd [This message has been edited by LiveOak (edited January 20, 2001).] Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8518 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now