Page 114 - Excle-En-V3

=IF(D2>89,"A", IF(D2>79,"B", IF(D2>69,"C", IF(D2>59,"D","F"))))
Follow the complex and logically nested IF statement directly:
1. If "Test Scores" in cell D2 is greater than 89, the student will receive an A grade.
2. If "Test Scores" are greater than 79, the student will receive a B grade.
3. If "Test Scores" are greater than 69, the student will receive a C grade.
4. If "Test Scores" are greater than 59, the student will receive a D grade.
5. Otherwise, the student will receive an F grade
=IF(B2>97,"A+",IF(B2>93,"A",IF(B2>89,"A-
",IF(B2>87,"B+",IF(B2>83,"B",IF(B2>79,"B-",
IF(B2>77,"C+",IF(B2>73,"C",IF(B2>69,"C-",IF(B2>57,"D+",IF(B2>53,"D",IF(B2>49,"D-
","F"))))))))))))
For further clarification, you can visit the following link:

https://support.microsoft.com/ar-
sa/office/%D8%AF%D8%A7%D9%84%D8%A9-ifs-36329a26-37b2-467c-
972b-4a39bd951d45

20. Common Errors:

(NAME# ،#Div/0! ،#REF ،########)
Error ####:
The column is not wide enough to display the value.

106 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024