You decided to award a 10% discount to a valuable customer and in D2 you calculated the discount amount that will appear on their monthly invoices using the 10% typed into A2. Because the % symbol is a mathematical operator, when you multiplied the figure in C2 by this cell, Excel worked out the 10 percent. You then used a Dollar sign in D2 so that you could use Autofill to correctly copy this formula down as far as D5.

You would like to use Copy and Paste to copy this block of formulas to the cells H2 to H5. If you copy and paste without any further adjustment, will they work correctly in the new location?

The Discount amount values are selected.