Increasing price list by a percentage

[chickenman1962]

Hi,
I'm relatively new to Excel, and have a problem that hopefully someone can help me with.
I created a basic spreadsheet, denoting current pricing for various quantities. Pricing fluctuates frequently, by percentages, and I'd like a formula that allows me to quickly increase, or decrease the contents of the cells by the given percentage.
I assume that one cannot do so without creating a copy of the original worksheet, then referring back to the original cell contents to populate the new worksheet's cells with the new value, to avoid a "circular" notice. Any help would be greatly appreicated. I'm simply needing some help creating a formula. The one I've tried adds .08 to the price, not 8% for some reason.

Regards,
Chickenman

 

[Brian from Maui]

If I understand correctly, in an empty cell enter 1.08 (for 8%), click copy, highlight the range of cells to change and go to Edit/Paste Special and tick multiply.

 

[Smitty]

Welcome to the Board!

In an unused cell you can enter 1.08-->Copy it-->highlight the range you want the increase applied to-->then Edit-->Paste Special-->Multiply.

Or you can add a column and use =A1*(1+$B$1), where A1 is the range of prices and B1 is the % increase to be applied.

Hope that helps,

Smitty

 

[chickenman1962]

For some reason, when I try the idea of clicking in a empty cell, typing in 1.08, copying it, highlighting the cells to apply this and do a paste special, it does not show me a box that contains the "multiply" choice.

Regards,
Chickenman

 

[atmospheric]

I had an almost identical problem:

http://www.mrexcel.com/board2/viewtopic.php?t=15381&highlight=