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