How do I multiply a whole column by a number?

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

Guest

I have a large worksheet that needs to be changed. I have payroll numbers
from last year that need to be changed. Last years payroll numbers need to
be multiplied by a 1.015 and replace last years #'s. How do I muliply the
whole column by 1.015 and have this show as the new numbers?
 
Hi there,

Take a COPY of the WORKBOOK and write 1.015 in any blank cell.

Copy the cell with '1.015' in it.
Highlight the payroll numbers (the whole column, but not the title cell if
you have one)
Paste Special (Edit, Paste Special) and select 'Values' and 'Multiply'.

All your Payroll numbers should now be their Original Value * 1.015.

Regards

Jim
 
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

Multiply by a rate depending on the value 3
Multiply a co;omn by a constant 2
I need calculated time in a "real number" format 2
Calculating payroll cost 1
multiplying 5
How do I multiply ALL CELL in spreadsheet at once by .5 ? 4
Excel Subtracting multiple columns from another column 3
How do I multiply either column 1 or column 2 by same multiplier? 2

Back
Top