adding a percentage to a column of numbers
 

I have a price sheet. I want to add a percentage to the price. A column of
prices, without doing to each cell. example 5*120%=11

adding a percentage to a column of numbers
 

Do you want to increase every price by 20% or by 120%? Your example is
incorrect, but implies an increase of 120% If so, choose an empty cell
somewhere and put 2.2 in that cell (2.2 = 220%, which is 120% on top
of 100%). Select that cell again and click <copy. Then move your
cursor and highlight the prices in the price column, then Edit | Paste
Special | Values (check) | Multiply (check) | OK, then <Esc

Then you can delete the 2.2 from the original cell.

If you meant to increase the prices by 20%, then you would start with
1.2 (120%) in the first cell.

Hope this helps.

Pete

On Sep 4, 11:53*pm, hld wrote:
I have a price sheet. I want to add a percentage to the price. A column of
prices, without doing to each cell. example 5*120%=11

adding a percentage to a column of numbers
 

put 1.2 in a vacant cellcopy that cellselect the columnedit paste
specialmultiply

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"hld" wrote in message
...
I have a price sheet. I want to add a percentage to the price. A column of
prices, without doing to each cell. example 5*120%=11

adding a percentage to a column of numbers
 

Enter 2.2 in an empty cell.

Copy that cell then select the range to change and paste
specialmultiplyokesc

Delete the 2.2


Gord Dibben MS Excel MVP



On Thu, 4 Sep 2008 15:53:01 -0700, hld
wrote:

I have a price sheet. I want to add a percentage to the price. A column of
prices, without doing to each cell. example 5*120%=11