How to add percentage to a number in excel?
Answers
Answered by
1
Enter the numbers you want to multiply by 15% in an empty column.
In an empty cell enter the percentage, which would be 15%, and then copy that number by pressing Ctrl + C.
Select the range of cells in cells in A1:A5 by dragging down the column.
Right click the selected cells, and then click Paste Special (do not click the arrow next to Paste Special).
Click Values > Multiply. Click OK.
And here’s the result: all the numbers multiplied by 15%.
In an empty cell enter the percentage, which would be 15%, and then copy that number by pressing Ctrl + C.
Select the range of cells in cells in A1:A5 by dragging down the column.
Right click the selected cells, and then click Paste Special (do not click the arrow next to Paste Special).
Click Values > Multiply. Click OK.
And here’s the result: all the numbers multiplied by 15%.
Similar questions