field increase

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I am not good at excel. We have price list in excel
format and I would like to increase them all by the same
percentage. Is this possible?
Thanks in advance.
Jeff
 
Hi Jeff!

In an mt cell, enter the amount of the increase. For
example, the increase is 10%, in cell A1 enter 1.1.
Then select cell A1 and copy it. Now select the range of
prices that you want to increase. Now select Paste
Special>Multiply>Ok.

Biff
 

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

Percentage Increase 13
Need Macro... 8
Pricing - Sliding Scale Price Markup 9
percentage in brackets 2
Increase Values by Percentage 1
Increasing numbers in a column by percentage 1
How can I add a similar amount to a full column of prices 4
How can I update pricebook increases in different percentages 3

Back
Top