Question

Create an EXCEL worksheet that invokes the following grading rules: Overall Score Grade 90 and above A 80 t0 89.9 B 70 to 79.9 C 60 to 69.9 D Below 60 F Have the user input a grade between 0 and 100. If user enters an invalid grade, the IF statement should display "INCORRECT GRADE".

Answer 1

You can make use of nested IF statement to solve this problem.

Step-by-step explanation:

The equation should look like this:

=IF(Score>=90,”A”,IF(Score>=80,”B”,IF(Score>=70,”C”,IF(Score>=60,”D”,IF(Score>=59,”F”,"INCORRECT GRADE")))))

On the cell wherein you wanted to output the result of the grade, you can write this formula:

=IF(A1>=90,”A”,IF(A1>=80,”B”,IF(A1>=70,”C”,IF(A1>=60,”D”,IF(A1>=59,”F”,"INCORRECT GRADE")))))

*A1 is the cell where the user will input the grade, then B1 is where you will type the formula to get the result of the letter grade.