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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

"David Biddulph" wrote:

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

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

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

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