Question: Task one. Regular Price in cell C12 by the Store Discount in cell C$8. Notice that we put an = at the beginning of our

Task one. "Regular Price" in cell C12 by the
Task one. "Regular Price" in cell C12 by the "Store Discount" in cell C$8. Notice that we put an "=" at the beginning of our formula to signal to Excel that we are doing a calculation. Because we want to reuse our formula for the rest of the "Discount" column, we use an absolute cell reference to the "Store Discount" in cell C8 (the '$' in the cell reference before the 8 will ensure that the row will increment when we paste the formula down in the "Discount" column). Copy your formula in ce C12 and paste it in cells D13 through D18

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!