Add 10% to a column of numbers

[Willyg1977]

I have a column of numbers which is used for pricing. I need to add 10% to it. How can I do this?

 

[Andrew Poulsom]

See:

http://j-walk.com/ss/excel/usertips/tip059.htm

 

[Mark W.]

On 2002-10-31 11:44, Willyg1977 wrote:
I have a column of numbers which is used for pricing. I need to add 10% to it. How can I do this?

Enter 1.1 into an unused cell (and, remove it when done), Copy, select your column of numbers, Paste Special... Values Multiply.

 

[ski]

Do you want to change the values to the new increased amount, or just display the new values alongside? The former is shown the in a previous post, the latter is really easy.

Use the formula "=A1*.1+A1" and fill it down the column.