close

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

In a blank cell enter 1.0008 (i.e. 0.08% increase) and click lt;copygt;

Then select the cell you want to apply this to and Edit | Paste Special
| Values (check) and Multiply (check) and click OK followed by lt;escgt; or
lt;entergt;

PeteIn 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.

quot;baquot; wrote:

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()