How to increase an entire collumn by a certain percentage?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a collumn of dollar amounts that I want to increase by a certain
mulaplier, say 35%. Is there any way to do this? The collumns are on
average 30 rows long, with various amounts.
 
In an empty cell somewhere type 1.35 (for 35%). Then do the following:
1. Select and copy that cell with 1.35 in it
2. Then select the column of numbers that you want increased by 35%
3. Click Edit/Paste Special
4. Under Paste, select "Formulas"
5. Under Operation, select "Multiply"
6. Click OK
 
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

Collumns 1
Filling in cells (or not) based on the entry in a specific collumn 3
Switching from collumns to rows 3
extracting from 1 collumn mailing list 2
subtotals (85 coll): Is there an easyer way than ticking 85 boxes 2
Collumns and rows 2
Multiple reports 2
How to change collumn heading numbers into letters? 1

Back
Top