Originally Posted by Gord Dibben

Assuming your column of prices is Column A.

In B1 enter =A1*1.2

Double-click on the fill handle(small black lump on bottom right corner) of B1
to fill down.

Easiest is to just type the number 1.2 in an empty cell and do the copypaste
specialmultipleOKEsc as Arv1 suggests. But this will overwrite the
originals.


Gord Dibben Excel MVP

On Mon, 16 May 2005 19:39:07 +0100, Glowinafuse
wrote:


Okay, I am new to this, and I am trying to understand. But where do you
put that formula? how... I need to learn this real quick for something
at work.



Arvi Laanemets Wrote:
Hi

a) With new price in new column (p.e. with price in cell A2)
=A2*1.2

b) When you want to overwrite old prices with new ones:
- Enter 1.2 into any free (empty) cell. Copy the cell;
- Select the renge with prices;
- from Edit menu, or from right-click drop-down, select Paste Special,
and
select Multiply option. OK.
It's done!


Arvi Laanemets



"Glowinafuse" wrote in message
...-

I have excel 200. I am wanting to add a certain percentage like 20%,
etc... to a column of prices. for example if the price on the column
was 10.00 it would increase it to 12.00(20% increase).

Can this be done.

Please help...

Thanks in advance,

Glowinafuse :)


--
Glowinafuse-