Page 105 - Excle
P. 105
IF 19.7.1
Nested IF (Excel IF function with multiple conditions
IF
False True
IF
IF
Nested IF if 160
=IF(D2>89,"A", IF(D2>79,"B", IF(D2>69,"C", IF(D2>59,"D","F"))))
IF
A 89 < 2D .1
B .2
C 79 < .3
D 69 < .4
59 < .5
F
– IF
AA A
12
= 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"))))))))))))
2024 © 99
