ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   increase the value of a cell by a percentage (https://www.excelbanter.com/excel-discussion-misc-queries/63384-increase-value-cell-percentage.html)

ba

increase the value of a cell by a percentage
 
How do i increase the value of a cell by a percentage and keep it in the
existing cell. I have a spreadsheet that has payment values in for customers.
I want to increase this amount by .08%. I have a mailmerge that creates
letters based on the amount in that cell that is why I need to keep it in the
same cell. thanks

Pete

increase the value of a cell by a percentage
 
In a blank cell enter 1.0008 (i.e. 0.08% increase) and click <copy

Then select the cell you want to apply this to and Edit | Paste Special
| Values (check) and Multiply (check) and click OK followed by <esc or
<enter

Pete


Sloth

increase the value of a cell by a percentage
 
In another cell input 1.0008.
Copy this cell and right click the cell you want to change.
Select Paste Special, and them select multiply.
Select Okay.

"ba" wrote:

How do i increase the value of a cell by a percentage and keep it in the
existing cell. I have a spreadsheet that has payment values in for customers.
I want to increase this amount by .08%. I have a mailmerge that creates
letters based on the amount in that cell that is why I need to keep it in the
same cell. thanks



All times are GMT +1. The time now is 02:51 PM.

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