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