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 `=H5*(1+I5)` example:

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