Solution to We want to grade students by using IF or Nested if statement. The student name … - Sikademy
Author Image

Archangel Macsika

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



Related Answers

Was this answer helpful?

Join our Community to stay in the know

Get updates for similar and other helpful Answers

Question ID: mtid-5-stid-8-sqid-3189-qpid-1888