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

  • Thread starter Thread starter Jackie
  • Start date Start date
J

Jackie

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
 
Back
Top