multiply entire column by %

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiply entire column by % 1
Multiplying the number in one cell and providing the product in an 4
row multiplier? 2
Column multiplied by a matrix 2
Formula Question 2
How do I use a calculated constant in multiple cells? 2
Time multiplied by cost per hr 2
Multiplying one cell by a column 5

Back
Top