1. Click cell F5 and type =(1+ to begin the formula
2. Select cell F4 and make it a mixed reference with the row as an absolute reference and the column as a relative reference.
3. Type )* for the closing parenthesis and multiplication
4. Click cell I5 on the Fleet sheet. Make it a mixed reference with the column as an absolute reference and the row as a relative reference. Hit Enter on the keyboard to enter the formula in cell F5.
5. 
6. 

D E F G I A B 1 San Diego Sailing 2 New Prices at 5% and 10% Increases 3 Half-Day Full Day 4 5% 10% 5 5 6 7 8 9 10 11 Boat ID Make and Model 1010 Catalina Wave 1015 Catalina Sky 1146 Hunter Ray 1150 Capri MKZ 1152 Capri 22 Mk 11 1164 Capri 22 Mk II 1168 Hunter 33 1175 Beneteau 40 1180 Beneteau 373 1185 Hunter Sea 1190 Beneteau 373 1200 Beneteau 373 1205 Beneteau 40 1225 Hunter Sea 1230 Catalina Wave Length 28'4" 28'4" 33'6") 24'8" 24'8" 24'8" 33'6") 39'10" 36'11" 35'6" 36'11" 36'11" 39'10" 35'6") 28'4" 5% $393.75 $446.25 $367.50 $341.25 $341.25 $341.25 $446.25 $513.45 $387.45 $366.45 $387.45 $387.45 $513.45 $366.45 $460.95 10% $412.50 $467.50 $385.00 $357.50 $357.50 $357.50 $467.50 $537.90 $405.90 $383.90 $405.90 $405.90 $537.90 $383.90 $482.90 12 13 14 15 16 17 18 19 20 Fleet New Prices Bookings Stats Patient Arrivals Operations + B4 for Make and Model A B F G H J 1 DE San Diego Sailing Rental and Charter Fleet 2 3 5 4 5 6 8 7 09 8 9 10 4 11 Model Galley Boat ID Make and Model Length Year Seats Sleeps with Stove 1010 Catalina Wave 28'4" 2010 8 6 1015 Catalina Sky 28'4" 2012 8 6 1146 Hunter Ray 33'6" 2014 10 6 1150 Capri MKZ 24'8" 2011 6 4 1152 Capri 22 Mk II 24'8" 2016 6 4 1164 Capri 22 Mk II 24'8" 2016 6 4 1168 Hunter 33 33'6" 2018 10 6 1175 Beneteau 40 39'10"| 2018 12 6 1180 Beneteau 373 36'11" 2017 10 6 1185 Hunter Sea 35'6" 2009 10 6 1190 Beneteau 373 36'11"| 2017 10 6 1200 Beneteau 373 36'11"| 2017 10 1205 Beneteau 40 39'10"| 2018 12 6 1225 Hunter Sea 35'6" 2012 10 6 1230 Catalina Wave 28'4"| 20191 8 61 Fleet New Prices Bookings Stats Patient Arrivals Half-Day Full Day Rate Rate $375.00 $650.00 $425.000 $725.00 $350.00 $500.00 $325.00 $500.00 $325.00 $500.00 $325.00 $500.00 $425.00 $725.00 $489.00 $750.00 $369.00 $725.00 $349.00 $550.00 $369.00 $625.00 $369.00 $625.00 $489.00 $750.00 $349.00 $725.00 $439.00l $675.00 Operations 12 13 14 0001010101010 15 16 17 18 19