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 Student name Marks Grade Shruti 42 Rakesh 97 Meena 66 Rahul 83
The Answer to the Question
is below this banner.
Can't find a solution anywhere?
NEED A FAST ANSWER TO ANY QUESTION OR ASSIGNMENT?
Get the Answers Now!You will get a detailed answer to your question or assignment in the shortest time possible.
Here's the Solution to this Question
=IF(B2>=90,"A+",IF(B2>= 80,"A",IF(B2>=65,"B",IF(B2<65,"c"))))