1. Edit the formula is cell D5 to show D$4 instead of D5. The formula should multiply one (1) plus the percentage value in cell D4 by the current rate on the Fleet sheet ($H5). With the absolute reference to row 4 and column H on the Fleet sheet, you can copy the formula

San Diego Sailing New Prices at 5% and 10% Increases Half-Day Full Day 10% 5% 10% Boat ID Make and Model 1010 Catalina Wave 1015 Catalina Sky 1146 Hunter Ray 1150 Capri MKZ 1152 Capri 22 Mk II 1164 Capri 22 Mk 11 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% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Fleet New Prices Bookings Stats Patient Arrivals Operations San Diego Sailing Rental and Charter Fleet 00 LO 10 4 Model Galley Half-Day Full Day Boat ID Make and Model Length Year Seats Sleeps with Stove Rate Rate 1010 Catalina Wave 28'4" 2010 8 6 $375.00 $650.00 1015 Catalina Sky 28'4" 2012 8 $425.00 $725.00 1146 Hunter Ray 33'6" 2014 6 $350.00 $500.00 1150 Capri MKZ 24'8") 2011 6 4 $325.00 $500.00 1152 Capri 22 Mk 11 24'8"| 2016 6 4 $325.00 $500.00 1164 Capri 22 Mk II 24'8" 2016 6 4 $325.00 $500.00 1168 Hunter 33 33'6" 2018 10 6 $425.00 $725.00 1175 Beneteau 40 39'10" 2018 12 6 $489.00 $750.00 1180 Beneteau 373 36'11"| 2017 10 6 $369.00 $725.00 1185 Hunter Sea 35'6"| 2009 10 6 $349.00 $550.00 1190 Beneteau 373 36'11"| 2017 10 6 $369.00 $625.00 1200 Beneteau 373 36'11"| 2017 10 6 $369.00 $625.00 1205 Beneteau 40 39'10" 2018 12 6 $489.00 $750.00 1225 Hunter Sea 35'6" 2012 101 6 $349.00 $725.00 1230 Catalina Wave 28'4" 2019 8 6. $439.00 $675.00 Fleet New Prices Bookings Stats Patient Arrivals Operations 6 6 San Diego Sailing New Prices at 5% and 10% Increases Half-Day Full Day 10% 5% 10% Boat ID Make and Model 1010 Catalina Wave 1015 Catalina Sky 1146 Hunter Ray 1150 Capri MKZ 1152 Capri 22 Mk II 1164 Capri 22 Mk 11 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% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 Fleet New Prices Bookings Stats Patient Arrivals Operations San Diego Sailing Rental and Charter Fleet 00 LO 10 4 Model Galley Half-Day Full Day Boat ID Make and Model Length Year Seats Sleeps with Stove Rate Rate 1010 Catalina Wave 28'4" 2010 8 6 $375.00 $650.00 1015 Catalina Sky 28'4" 2012 8 $425.00 $725.00 1146 Hunter Ray 33'6" 2014 6 $350.00 $500.00 1150 Capri MKZ 24'8") 2011 6 4 $325.00 $500.00 1152 Capri 22 Mk 11 24'8"| 2016 6 4 $325.00 $500.00 1164 Capri 22 Mk II 24'8" 2016 6 4 $325.00 $500.00 1168 Hunter 33 33'6" 2018 10 6 $425.00 $725.00 1175 Beneteau 40 39'10" 2018 12 6 $489.00 $750.00 1180 Beneteau 373 36'11"| 2017 10 6 $369.00 $725.00 1185 Hunter Sea 35'6"| 2009 10 6 $349.00 $550.00 1190 Beneteau 373 36'11"| 2017 10 6 $369.00 $625.00 1200 Beneteau 373 36'11"| 2017 10 6 $369.00 $625.00 1205 Beneteau 40 39'10" 2018 12 6 $489.00 $750.00 1225 Hunter Sea 35'6" 2012 101 6 $349.00 $725.00 1230 Catalina Wave 28'4" 2019 8 6. $439.00 $675.00 Fleet New Prices Bookings Stats Patient Arrivals Operations 6 6