Increase a value by a % with result showing in original cell?

G

Guest

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!
 
B

Bob Phillips

In a separate cell enter 104%

Then select all cells to change
Goto Edit>Pastespecial, click Multiply, and OK

Then clear the 104%

--

HTH

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top