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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In a sales quote sheet - sum totals by license type 1
Best (Easiest) to Multiply Columns by a Constant? 7
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Take Data From Other Files 2
copy down 4
This will sound ridiculous but... 5
Transpose large data from columns to rows 3
Vlookup or similar 7

Back
Top