1 amount in 1 cell this amout onther cell autometically how in excell
Answers
Answered by
0
Here’s how to do it:
Enter the numbers you want to multiply by 15% into a column.
In an empty cell, enter the percentage of 15% (or 0.15), and then copy that number by pressing Ctrl-C.
Select the range of cells A1:A5 (by dragging down the column).
Right-click over the cell selection, and then click Paste Special (do not click the arrow next to Paste Special).
Click Values > Multiply, then click OK.
The result is that all the numbers are multiplied by 15%.
Enter the numbers you want to multiply by 15% into a column.
In an empty cell, enter the percentage of 15% (or 0.15), and then copy that number by pressing Ctrl-C.
Select the range of cells A1:A5 (by dragging down the column).
Right-click over the cell selection, and then click Paste Special (do not click the arrow next to Paste Special).
Click Values > Multiply, then click OK.
The result is that all the numbers are multiplied by 15%.
Similar questions