Answer to Question #179900 in Discrete Mathematics for Sunny

Question

We want to grade students by using IF or Nested if statement. The student name and marks are given. Write an IF or Nested IF statement to arrive at their grades i the grade column. The marks and the grades are as follows:

Less than 65 marks = c grade

More than or equal to 65 marks and less than 80 = B grade

More than or equal to 80 marks and less than 90 = A grade

More than or equal to 90 marks = A + grade

A B C

1. Student name Marks Grade
2. Shruti 42
3. Rakesh 97
4. Meena 66
5. Rahul 83

Answer 1

=IF(B2>=90,"A+",IF(B2>= 80,"A",IF(B2>=65,"B",IF(B2<65,"c"))))