contestada

The score of five students in a subject are inserted in row B from B2 to B6 cells and the grades for the scores are: A: 90 to 100, B: 80 to 89, C: 70 to 79, D: 60 to 69, and F: 0 to 59. What functions can you insert in the D2 cell so that it returns the grade for each score in row B?

Respuesta :

MrRoyal

Answer:

=IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C",IF(B2>=60,"D","F"))))

Step-by-step explanation:

The function to use is an if function.

The syntax of the if function is as follows;

=IF (condition1, value_if_true1, IF (condition2, value_if_true2, IF (condition3, value_if_true3, value_if_false3)))

Given that the grading system is as follows

A: 90 to 100,

B: 80 to 89,

C: 70 to 79,

D: 60 to 69, and

F: 0 to 59.

The function becomes

=IF(B2>=90,"A",IF(B2>=80,"B",IF(B2>=70,"C",IF(B2>=60,"D","F"))))

Type the above in cell D2

The above will check for each condition and determine the appropriate output.

For example if B2 is within the range of 70 to 79; the function stops at B2>70 and outputs the corresponding grade in cell D2

Otras preguntas