How to increase all prices in price sheet by certain percent?

[happylady]

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

 

[Arceedee]

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

 

[muddan madhu]

Col A - Price list of products

if u want to replace in old price then
in Cell C1 type 1.05
then copy it
Select the range that you want to replace
now go edit | pastespecial | paste : all | operation : multiply | ok

Or

It you want the increased value in separate column then,

Cell B1 put this formula and drag it down =A1+A1*5%

 

[Arceedee]

Read the question. She needs to increase her price by 5% not just show 5% of
her original price. My formula works and increases the original price by 5%
and adds the original figure back in to give the new price. Simple maths

 

[Arceedee]

It works. I don't need to explain anything; especially to you. END

 

[happylady]

Thank you Arceedee and David Biddulph for the quick responses. I just got
into my office on a lazy Sat. morning. However, I have to confess I am less
that an inexperienced 'newbie'. What is, obviously, so simple for you,
scrambles my upstairs gears. I have never worked in Excel, I had a bookkeeper
that did it all, and she is no longer with me, so__________. I will take
these formulas and see how they work (I think)! Muddan Madhu (thank you!)
gave a step by step also, plus I have Office 2003 All In One manual, and
hopefully I can figure this out.

Again, thank you much!

Happylady

 

[happylady]

Thanks for this step by step. Now with my manual, as an extra guide I think I
can do it!

Happylady