View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Arceedee Arceedee is offline
external usenet poster
 
Posts: 96
Default How to increase all prices in price sheet by certain percent?

If your original value is in cell A1 the following formula in B1 will do it:
=SUM(A1*5%)+A1
Format to 2 decimal places

"happylady" wrote:

I have received an across the board price increase for all the products in
the line I distribute. I want to put my product price list in Excel and be
able to increase all the products prices by 5%. Otherwise I have to type in
the price change on each individual product. Can I do this in Excel and how?

happylady