B
Brittany
I need to increase all the numbers in a column by 10%. Can anyone help me?
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.
In Excel how do I increase the amount in an entire column by a %?
T
tim m
If your original number was in A1 you could use the formula below.
=A1*1.1
=A1*1.1
D
Don Guillett
in a cell somewhere put 1.1
copy that cell
select your range
edit>paste>multiply
copy that cell
select your range
edit>paste>multiply
B
bpeltzer
In some empty cell, enter the number 1.1. Copy (ctrl+c) that cell. Then
select your column of numbers and Edit > Paste Special. Select VALUES and
MULTIPLY then click OK.
select your column of numbers and Edit > Paste Special. Select VALUES and
MULTIPLY then click OK.
M
Marcelo
type 1.1 in on cell, copy it and paste special as multiply
HTH
Regards from Brazil
Marcelo
"tim m" escreveu:
HTH
Regards from Brazil
Marcelo
"tim m" escreveu: