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
|