Remember to type on the spreadsheet: -Your Name -Your Class Period -The Day (Odd/Even) -Remember to Display Formulas before printing. (Control + ~) -See page 55 Project 4C for help with the IF Formula. Your spreadsheet should look something like this:
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