formula to change entire tariff table

[Hurricane Matt]

I run company that requires a tariff rate sheet indicating prices per lb for multiple origins and destinations. We have the table set up and the prices need to change every few months and it's extremely labor intesive to change each rate per lb. What formula do I need to use to increase all these varying rates by x percent across the board?

[JBeaucaire]

If you want to increase all prices by 3%, then in a cell type 1.03 and copy that cell.

Now highlight ALL your prices at once, click on Edit > Paste Special > Operation: Multiply and all your prices will be multiplied by 1.03. And you're done. You don't have to remember anything later. And the changes are IN the cells as actual values.

[Hurricane Matt]

Thank you for your help, one more question. If we want to add x cents per lb across the board for varying rates, not a percentage,is that a different formula? Thank you, Matt

[JBeaucaire]

Well, you've seen how to use Multiply in the Paste Special menu. Go ahead and experiment with the other options, like Add. Sounds like that's what you want.

[Hurricane Matt]

Hi again, we are not used to 2007 version, i cant find edit button, where is that? is there any other obstacles that I might run into with this new version? Thanks again, Matt

[JBeaucaire]

http://www.uwec.edu/HELP/Excel07/ws-pastesp.htm

[Hurricane Matt]

Hi there, we need to solve another problem.
If we have one price of $967 and another for $1000 we need the formula to show what percentage is the difference in the two prices. Thank you.

[JBeaucaire]

Up to you to determine which is the priority, so here are both formulas:

A1 = 967
B1 = 1000
C1 =ABS(1-B1/A1) = 3.41%
D1 =ABS(1-A1/B1) = 3.30%