$% Conditional Format Formatting as Table Styles Cell Styles han Number Paste B 1 Format U Merge & Center Clipboard Font Alignment Omce Update To keep up-to-date with security updates, fans, and improvements, choose Check for Updates x x B c D F G H 1 Department Employee List Hire Date Years Salary Salary + COLA Cost of Living Allowance (COLA): 2.1% 1. In F3, calculate Lisa Page's Salary that includes the extra COLA allowance 2. Copy the formula in F3 down to F14. 1 Employee Name 2 3 Page, Lisa 4 Taylor, Hector 5 Dawson, Jonathan 6 Weber, Larry 7 Pratt, Erik 8 Spencer, Boyd 9 Wiggins, Frank 10 Tanner, Timothy 11 Chase, Troy 12 Wilkins, Jesse 13 White, Daniel 14 Holland, Donald 15 16 17 18 19 20 21 22 22 Sales Sales Administration ADC Sales Marketing Training Sales Training Marketing Administration Training 11-Nov-99 21-Aug-11 6-Jul-07 31-Dec-07 3-Sep-06 17-Apr-07 10-Apr-99 28-May-02 4-Jun-04 15-Jan-12 26-Aug-00 1-Sep-11 20 $54,550 9 $26,795 13 $142,540 12 $72,830 13 $60,830 13 $66,580 21 $75,150 18 $30,780 16 $49,350 8 $79,760 20 $274,840 $29,070 24 25 26 27 28 + Cal NetPay IF function Asolute Instructions YTD and Pet Increase CopyFormulas Formulas