Jump to content

Letter Grade Formula


This topic is 2494 days old. Please don't post here. Open a new topic instead.

Recommended Posts

What could be the reason for anything coming through on the Final Grade higher than "100" showing up as a "B+" in the system. I added in a solution for it to look for a "100" in the Final Grade slot but then made every option an "A+".

 

If(IsEmpty ( Sub1Final_Grade );""; Case ( Sub1Final_Grade  ≥ "96.5" ; "A+" ; Sub1Final_Grade  ≥  "92.5" ; "A" ; Sub1Final_Grade  ≥  "89.5"; "A-" ; Sub1Final_Grade  ≥ 86.5; "B+";  Sub1Final_Grade ≥ 82.5 ; "B" ; Sub1Final_Grade ≥ 79.5 ; "B-" ; Sub1Final_Grade ≥ 76.5 ; "C+" ; Sub1Final_Grade ≥ 72.5 ; "C" ; Sub1Final_Grade ≥ 69.5 ; "C-" ; Sub1Final_Grade  ≥ 66.5 ; "D+" ; Sub1Final_Grade  ≥ 64.9 ; "D" ; Sub1Final_Grade < 64 ; "F" ; ""))

Link to comment
Share on other sites

I seem to have problems communicating properly with you. A screenshot is not a file. And I have asked you before to format your calculations and place them inside a code block. Had you done so, I would have seen the problem right away: you have quotes around the first three threshold values ("96.5", "92.5" and "89.5"). That makes them text values - and the comparison is done in the text domain (i.e. alphabetically), where "100" comes before "96.5". The next threshold value, 86.5, is not quoted and therefore is the first one that is less than 100.

Please show more consideration for the time of people trying to hep you.

 

Link to comment
Share on other sites

I do apologize. I was trying to find that feature, "code block" when I was formatting my question to send but could not find it. Is that just the "code" feature at the top? I'm sorry for the inconvenience for your time. I'm new and trying to figure out the ropes of this board. Thank you for your time.

Link to comment
Share on other sites

This topic is 2494 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.