Hint – Page 63 – Assessment #4

Example from – p.54 4B

=IF(E16>89,”A”,IF(E16>79,”B”,IF(E16>69,”C”,IF(E16>59,”D”))))

Hint for – p.63 Assessment #4

C4

=IF(B4>X, “Platinum”,IF(B4>100000,”X“, IF(B4>75000,”X“,IF(B4>X, “X“))))

D4

=IF(C4=”Bronze”,”None”,IF(C4=”X“,3000,IF(C4=”X“,X,IF(X=”X“,X