Products by column constants

  • Thread starter Thread starter conttext
  • Start date Start date
C

conttext

A ver y simple question for your experts. I have a column of number
that I want to multiply by a constant ( a price list tthat I need t
increase by 5%). How to do? I can do one line at a time but how do I d
the entire column
 
conn

Enter 1.05 in a cell.

Copy this.

Select your data column and Paste Special>Multiply>OK>Esc.

If you set up your formulas initially with a multiplier cell in the formula
you can just change the value in the multiplier cell.

e.g.

Formula in C1 =(A1+B1)*D1

Change the value in D1 and the result in C1 will change.

Gord Dibben Excel MVP
 
Back
Top