![]() Now, right-click on the mouse and select Copy from the context menu. Paste Special function gives us the option to get values instead of formulas.įirst, we have copied values from columns D5 to D9 into columns E5 to E9. Method 4: MultiplyTwo Columns Using Paste Special Read More: How to Multiply a Column by a Number in Excel (4 Easy Methods) Now, right-click the mouse button and drag it down to the end of the column to get the results. ![]() Therefore, the formula in F6 changes to =C6*D6*(1-$E$7) the formula in F7 changes to =C7*D7*(1-$E$7), and so on. You use a Relative Cell Reference (like C4) for the topmost cell in the column, as a result of the relative location of a cell where the formula is copied, this reference changes. You use an Absolute Cell Reference (like $E$7) to ensure that the column and row coordinates of the cell containing the number to multiply by do not change while copying the formula to other cells. Here, we subtracted the discount value to get the total Sales after the discount. Also used Absolute Reference for cell E7.
0 Comments
Leave a Reply. |