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%

 

[David Biddulph]

I assume that you meant either
=SUM(A1*5%,A1)
or
=(A1*5%)+A1 ?

If not, perhaps you could explain to us in what way you expect =SUM(A1*5%)
to be different from =A1*5% ?

And don't forget that if you format the *display* to 2 decimal places,
rather than rounding to 2 decimal places, you may get different results when
you use the value compared with what you expect from the display.

 

[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

 

[David Biddulph]

Read my answer. You obviously missed the part where I asked:
" If not, perhaps you could explain to us in what way you expect =SUM(A1*5%)
to be different from =A1*5% ?"

Perhaps you aren't familiar with what the SUM function in Excel does. You
may wish to look it up in Excel help.

 

[Arceedee]

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

 

[David Biddulph]

Yes.
=SUM(A1*5%) works.

Some other things which would work are
=MIN(A1*5%)
=MAX(A1*5%)
=MEDIAN(A1*5%)
=AVERAGE(A1*5%)
=PRODUCT(A1*5%)
but the use of any of those functions would be as pointless as the use of
the SUM function in that context.

I'm glad that you're happy merely to provide an answer, but some of us also
try to help less experienced readers of the group to learn. *Some* readers,
of course, have no wish to learn.

 

[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