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.
--
David Biddulph

Arceedee wrote:
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" wrote:

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. --
David Biddulph

"Arceedee" wrote in message
...
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