A
anna
How can I increase the current cell value by 10 % in Excel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jerry W. Lewis
Copy the number 1.1 (or equivalently 110% from another cell and
Edit|Paste Special|Multiply
Jerry
Edit|Paste Special|Multiply
Jerry
J
JE McGimpsey
To show the increase in another cell:
A1: 10
B1: =(1 + 10%) * A1 ===> 11
or a little more simply:
B1: =1.1*A1
To increase the value in-place:
Enter 1.1 in a blank cell. Copy the cell. Select the cell(s) to
increase by 10%. Choose Edit/Paste Special, selecting the Multiply and
Add radio buttons. Click OK.
A1: 10
B1: =(1 + 10%) * A1 ===> 11
or a little more simply:
B1: =1.1*A1
To increase the value in-place:
Enter 1.1 in a blank cell. Copy the cell. Select the cell(s) to
increase by 10%. Choose Edit/Paste Special, selecting the Multiply and
Add radio buttons. Click OK.
B
Biff
Hi Anna!
In an empty cell enter 1.1
Now, copy that cell
Select the cell you want to increase by 10%
Then do: Paste special
Click: Multiply
Ok
Biff
In an empty cell enter 1.1
Now, copy that cell
Select the cell you want to increase by 10%
Then do: Paste special
Click: Multiply
Ok
Biff
J
JE McGimpsey
Correction: Multiply and Values radio buttons.