For this example, make sure you have clicked into cell J5 of theworksheet used in the preceding example. Our task is to work out thepercentage increase for product prices in-store and add this to thecurrent product price. We are also having a store sale and would like toreduce our prices by a certain percentage and arrive at the new saleprice.
To work out this formula, we would need to take the
Type the formula =H5*(1+I5) into the cell J5 and use theAutoFill handle to copy the formuladown to the rest of the cells. Note that you can adjust