Page 1 of 1

[Solved] Adding amount to a selection

PostPosted: Wed Dec 12, 2007 5:45 am
by adrian
To add a certain amount to every number in a column? Like i have a column full of different number values... is there a way to increase all of them by the same number like 20?

 Edit: Changed the title (was "Is there a way...") and tagged the thread as Solved, even if no feedback from OP.

Re: Is there a way...

PostPosted: Wed Dec 12, 2007 9:19 am
by Hagar Delest
Type 20 in a cell, copy it then paste special (either CTRL+SHIFT+V or Edit>Paste special) and on the right, select Add.

Thanks to add '[Solved]' in your first post title (edit button) if your issue has been fixed.

Re: Is there a way...

PostPosted: Wed Dec 12, 2007 6:55 pm
by acknak
Hagar's suggestion is good, and easy, but if the original values are your raw data, you may wish to preserve them, so in the future you can go back and see exactly what was done, and back it out or otherwise change the analysis.

If that is the case, you can do the addition by changing the current values to a formula:

Select the cells to change
Edit > Find & Replace
Search for: .*
Replace with: =&+20
Options / Regular expressions: YES
Options / Current selection only: YES
Replace all

This changes a value, like "123.45" to a formula: =123.45+20, so the original data are still there, if you ever need to know.

Even better, if you can, just use a separate column for the calculation.