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.

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.

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.

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.

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.