ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Increasing numbers in a column by percentage (https://www.excelbanter.com/excel-worksheet-functions/62361-increasing-numbers-column-percentage.html)

dekare

Increasing numbers in a column by percentage
 
Excel 2003. I would like to increase a lengthy list of numerical pricing in a
column by a percentage or in this case by 8 1/2%. I can't seem to find any
information that supports a quick way to do this.

bpeltzer

Increasing numbers in a column by percentage
 
In an empty cell, enter 1.085. Copy that cell (ctrl + c). Select the range
you want adjusted and Edit Paste Special, select Multiply and click OK.

"dekare" wrote:

Excel 2003. I would like to increase a lengthy list of numerical pricing in a
column by a percentage or in this case by 8 1/2%. I can't seem to find any
information that supports a quick way to do this.



All times are GMT +1. The time now is 01:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com