multiply entire column by %

M

marc@ops2

I need to multpy all of the cell contents (currency) of a single column by a
specific percentage. Basically what I'm doing is taking a list of product
costs and calculating markups. Anyhelp would be greatly appreciated as I am
at a total lost and can't find help anywhere

thanks
Marc
 
B

Biff

Hi Marc!

If you want to multiply by a percentage:

In an empty cell enter the percentage, say .25.
Now copy that cell. Then select the range of cells that
you want to change and do Edit>Paste Special>Multiply>OK.

Now, if you want to increase those cells by a percentage,
in the empty cell enter 1.25 and then do the Copy>Paste
Special>Multiply.

Biff
 
Top