Apr 08 2019 09:50 AM
This formula examines a number and outputs the corresponding letter grade it works on every class grade except B4 where it says the letter grade is "D" when I have a 70.
=IFS(B5>=90,"A",B5>=80,"B",B5>=70,"C",B5>=60,"D",B5<60,"F")
A B
1 98 A
2 70 C
3 80 B
4 70 D
Apr 08 2019 09:56 AM
@Hayden Alston does column A have any rounding going on? If a 69.9 is displayed as a 70, it would evaluate as a "D".
Apr 08 2019 10:04 AM
that was the problem i set the grades to be two decimals and the number with more that two decimals is 69.997@rdwyer
Apr 08 2019 10:11 AM
i just made the numbers half a point lower to include the rounding @rdwyer
Apr 08 2019 10:15 AM
@Hayden Alston You can add another column and use the ROUND function to handle this, then evaluate the rounded numbers for letter grades.
Apr 08 2019 10:51 PM