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

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

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

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