We resell equipment with a 30% upcharge for profit. How can I increase all $
amounts to include the upcharge without manually re-entering the amount?

I am relatively new at this. Thanks!

Say the $ amount are in a given column, say column G. In an unused cell enter:

1.3

copy this cell and:

Edit Paste Special Multiply onto the cells in column G
--
Gary''s Student - gsnu200777


"~D.." wrote:

We resell equipment with a 30% upcharge for profit. How can I increase all $
amounts to include the upcharge without manually re-entering the amount?

I am relatively new at this. Thanks!

Hi,

Assuming you have a column with your purchase price in you can do it in a
couple of ways:-

Put this in and adjacent column and drag down
=A1*1.3

Or

Put 1.3 in a cell somewhere and copy it.
Select your original prices and then
Edit|Paste special
Select multiply and click OK
delete the cell with 1.3 in

Mike

"~D.." wrote:

We resell equipment with a 30% upcharge for profit. How can I increase all $
amounts to include the upcharge without manually re-entering the amount?

I am relatively new at this. Thanks!

Copy a cell that contains 0.3 and then select all the "amounts" and then
click Edit, Paste Special, Multiply.

~D.. wrote:

We resell equipment with a 30% upcharge for profit. How can I increase all $
amounts to include the upcharge without manually re-entering the amount?

I am relatively new at this. Thanks!

Whoops! 1.3 not 0.3!

Bob I wrote:

Copy a cell that contains 0.3 and then select all the "amounts" and then
click Edit, Paste Special, Multiply.

~D.. wrote:

We resell equipment with a 30% upcharge for profit. How can I
increase all $ amounts to include the upcharge without manually
re-entering the amount?

I am relatively new at this. Thanks!