I have a business (Fence chainlink etc.) that uses price pages for our sales
personel and when we have a price increase I usually use a calculator and
say it is a 10% increase from our supplier figure each number and type in the
new price. With hundreds of items in 36 pages, this takes days to complete.
I have been trying to find a formula in Excel to increase an entire column
with a formula to change each price by say 10% or whatever percent the
increase is. I can use formulas that work but I always have to use another
column to show the increase. How can I do this to just change the number in
the same cell and copy down an entire column? Then I just print the new
pages with the new date.
--
dc

Try this:

In a blank cell, enter 110%
Copy that cell

Select the range of cells to be increased by the 10%.

From the Excel main menu:
<edit<paste special
Check: Multiply
Click the [OK] button...done!

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"dcasdos" wrote:

I have a business (Fence chainlink etc.) that uses price pages for our sales
personel and when we have a price increase I usually use a calculator and
say it is a 10% increase from our supplier figure each number and type in the
new price. With hundreds of items in 36 pages, this takes days to complete.
I have been trying to find a formula in Excel to increase an entire column
with a formula to change each price by say 10% or whatever percent the
increase is. I can use formulas that work but I always have to use another
column to show the increase. How can I do this to just change the number in
the same cell and copy down an entire column? Then I just print the new
pages with the new date.
--
dc

Actually, you also need to check Values in the Paste Special window or all of
the prices will become percents.

This way:
<edit<paste special
Check: Multiply
Check: Values
Click the [OK] button

(Sorry for skipping that step in my first post.)
***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Try this:

In a blank cell, enter 110%
Copy that cell

Select the range of cells to be increased by the 10%.

From the Excel main menu:
<edit<paste special
Check: Multiply
Click the [OK] button...done!

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"dcasdos" wrote:

I have a business (Fence chainlink etc.) that uses price pages for our sales
personel and when we have a price increase I usually use a calculator and
say it is a 10% increase from our supplier figure each number and type in the
new price. With hundreds of items in 36 pages, this takes days to complete.
I have been trying to find a formula in Excel to increase an entire column
with a formula to change each price by say 10% or whatever percent the
increase is. I can use formulas that work but I always have to use another
column to show the increase. How can I do this to just change the number in
the same cell and copy down an entire column? Then I just print the new
pages with the new date.
--
dc

Thank you so much for you help, I would of never figured this out, and you
explained it in such an easy way. I've been trying for months to figure
this out. We novices out here are fortunate to have people like you to give
of your time and knowledge to help others.

sincerely
David Casados
--
dc


"dcasdos" wrote:

I have a business (Fence chainlink etc.) that uses price pages for our sales
personel and when we have a price increase I usually use a calculator and
say it is a 10% increase from our supplier figure each number and type in the
new price. With hundreds of items in 36 pages, this takes days to complete.
I have been trying to find a formula in Excel to increase an entire column
with a formula to change each price by say 10% or whatever percent the
increase is. I can use formulas that work but I always have to use another
column to show the increase. How can I do this to just change the number in
the same cell and copy down an entire column? Then I just print the new
pages with the new date.
--
dc