How to take 1 column $ amount & put in another column - 2%
 

I have a price book and want to add a column to reflect 2% off. The costs
are in Column (H) and I want to show the cost - 2% in column (J) When I
started this I only had a hand full to change and I did this by going into
each cell and typed in =sum(H13-(H13*0.02)) I now have the whole book to
change to show the 2% off. That's 500 + rows. These has to be a better way.
I have asked several people who work with excel and they could not help me
and I also looked on line.

How to take 1 column $ amount & put in another column - 2%
 

You can just copy the formula and paste it all the way down. If the data is
columnar form then your formula pasted to the next cell would be

sum(H14-(H14*.02)) and so on

"Jackie" wrote:

I have a price book and want to add a column to reflect 2% off. The costs
are in Column (H) and I want to show the cost - 2% in column (J) When I
started this I only had a hand full to change and I did this by going into
each cell and typed in =sum(H13-(H13*0.02)) I now have the whole book to
change to show the 2% off. That's 500 + rows. These has to be a better way.
I have asked several people who work with excel and they could not help me
and I also looked on line.

How to take 1 column $ amount & put in another column - 2%
 

Try this:

=ROUND(H13*0.98,2)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Jackie" wrote in message
...
I have a price book and want to add a column to reflect 2% off. The costs
are in Column (H) and I want to show the cost - 2% in column (J) When I
started this I only had a hand full to change and I did this by going into
each cell and typed in =sum(H13-(H13*0.02)) I now have the whole book to
change to show the 2% off. That's 500 + rows. These has to be a better
way.
I have asked several people who work with excel and they could not help me
and I also looked on line.

How to take 1 column $ amount & put in another column - 2%
 

Firstly you don't need the SUM()
=H13-(H13*0.02) or =H13*(1-2%) will do.

There are a number of ways of copying your formula down your 500 rows:
Copy your J13, then select the range into which you want to copy, then
paste, or
Select the bottom right hand corner of J13, where you'll see a black square
called the fill handle. Drag that down your column, or
If you have data in the adjacent column you can just double-click on the
fill handle of J13 and it will auto-fill down as far as you have data in
column I.
--
David Biddulph

"Jackie" wrote in message
...
I have a price book and want to add a column to reflect 2% off. The costs
are in Column (H) and I want to show the cost - 2% in column (J) When I
started this I only had a hand full to change and I did this by going into
each cell and typed in =sum(H13-(H13*0.02)) I now have the whole book to
change to show the 2% off. That's 500 + rows. These has to be a better
way.
I have asked several people who work with excel and they could not help me
and I also looked on line.

How to take 1 column $ amount & put in another column - 2%
 

Firstly you don't need the SUM()
=H13-(H13*0.02) or =H13*(1-2%) will do.

and you don't need braces either
=H13-H13*0.02


"David Biddulph" wrote:

Firstly you don't need the SUM()
=H13-(H13*0.02) or =H13*(1-2%) will do.

There are a number of ways of copying your formula down your 500 rows:
Copy your J13, then select the range into which you want to copy, then
paste, or
Select the bottom right hand corner of J13, where you'll see a black square
called the fill handle. Drag that down your column, or
If you have data in the adjacent column you can just double-click on the
fill handle of J13 and it will auto-fill down as far as you have data in
column I.
--
David Biddulph

"Jackie" wrote in message
...
I have a price book and want to add a column to reflect 2% off. The costs
are in Column (H) and I want to show the cost - 2% in column (J) When I
started this I only had a hand full to change and I did this by going into
each cell and typed in =sum(H13-(H13*0.02)) I now have the whole book to
change to show the 2% off. That's 500 + rows. These has to be a better
way.
I have asked several people who work with excel and they could not help me
and I also looked on line.