MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help changing a price list by a given percentage markup


Posted by Carol on July 22, 2001 1:13 PM

I need to update price lists from a distributor to reflect an 'across the board' percentage increase before the prices are posted as retail.

The price lists come from the distributor in a spread sheet format. Is there a simple way to highlight the price column and automatically calculate a given percentage increase for each item?

Thanks for any help. I know very little about Excel or spread sheets for that matter.


Posted by Aladin Akyurek on July 22, 2001 1:26 PM

Lets say that the distributor's price list in A from A2 on.

In B1 enter: the percenatge (either in decimal style or in percent style)

While in B1, go the Name Box and type e.g., Increase [ this cell gets this way a name. ]

In B2 enter: =A2+A2*Increase [ or =A2*(1+Increase) ]

Copy down the last formula as far as needed.

Aladin