ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Increase a value by a % with result showing in original cell? (https://www.excelbanter.com/excel-discussion-misc-queries/103606-increase-value-%25-result-showing-original-cell.html)

ASmith

Increase a value by a % with result showing in original cell?
 
Is there a way to increase a value in a cell by a percentage and have the
result show in the same cell as the original value? I'm trying to apply a 4%
increase to some prices and would rather not calculate each value but instead
apply a formula to change the cells across the board. Thanks!


Bob Phillips

Increase a value by a % with result showing in original cell?
 
In a separate cell enter 104%

Then select all cells to change
Goto EditPastespecial, click Multiply, and OK

Then clear the 104%

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"ASmith" wrote in message
...
Is there a way to increase a value in a cell by a percentage and have the
result show in the same cell as the original value? I'm trying to apply a

4%
increase to some prices and would rather not calculate each value but

instead
apply a formula to change the cells across the board. Thanks!





All times are GMT +1. The time now is 11:30 AM.

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