How do I multiply a whole column by a number?
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 "cowboyeti" wrote: 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? |
All times are GMT +1. The time now is 11:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com