Edit the formula in cell D2 so the references to cell C2 will update when the formula is copied, and the reference to cell B9 will remain constant. Use AutoFill to copy the formula to cells D3:06. Salaries - Excel File Home Insert Page Layout Formulas Data Review View Tell me what you want to do... D IAI Calibri Et Wrap Text A A 12 AutoSum En HH Custom BE * Cut e Copy Format Painter H Fill Paste Merge & Center - BIU 8-A- 7 $ - % +0.00 .000 Insert Delete Format Clear - Conditional Format Cell Formatting as Table - Styles Styles Z Sort Find & Filter & Select Editing Clipboard Font 5 Alignment Number Cells D2 fr =C2+(C2*B9) A B C D E F G H 1 K L M N 1 Year 4 54,080 2 Sue Chur 3 Anne Coll 4 Ben Delbow 5 Dr. Patella 6 John Patterson 7 Total Gross Salaries 8 9 COLA 10 Year 1 $ $ $ $ $ $ Year 2 Year 3 50,000 $ 52,000 $ 45,000 $ 47,500 65,000 $ 69,000 115,000 $ 120,000 105,000 $ 109,000 380,000 $ 397,500 $ 54,080 $ 4% 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Salaries maadhi