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

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

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

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

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

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

"David Biddulph" wrote:

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

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%




On Jan 31, 12:07*pm, 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

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

Happylady

"muddan madhu" wrote:

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%




On Jan 31, 12:07 pm, 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