Letter Grade Formula

[jmille011]

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" ; ""))

[comment]

17 minutes ago, jmille011 said:

anything coming through on the Final Grade higher than "100" showing up as a "B+" in the system

Please post an example file (one record, two fields) showing this.

[jmille011]

Here you go.

[comment]

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.

 

[jmille011]

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.

[Lee Smith]

See if this helps .