software

for instance in column c from row 5 to row 455 I want to add .27 to every
number that is already in each cell

example c5 has 9.09 already in it, I want to add .27 for a new total of 9.36

I then want to copy that formula so that it does the same thing all the way
to c455

Hi JCE,

Select a Cell and Type =C5 0.27 where C stands for column and 5 stands for row
drag the active cell downward to see the next row result then you may copy
the formula to other worksheets or cells buy using copy and specialpaste.
Hope this helps.

quot;JCEquot; wrote:

gt; for instance in column c from row 5 to row 455 I want to add .27 to every
gt; number that is already in each cell
gt;
gt; example c5 has 9.09 already in it, I want to add .27 for a new total of 9.36
gt;
gt; I then want to copy that formula so that it does the same thing all the way
gt; to c455

If you just want to add 0.27 as a once off to all those cells
You can simply type 0.27 in any cell - select it and choose COPY

Then select C5:C455
Go to EDIT gt; PASTE SPECIAL
From the paste section choose VALUES
From the operation section choose ADD
Then Click the OK button

GeorgeJCE wrote:
gt; for instance in column c from row 5 to row 455 I want to add .27 to every
gt; number that is already in each cell
gt;
gt; example c5 has 9.09 already in it, I want to add .27 for a new total of 9.36
gt;
gt; I then want to copy that formula so that it does the same thing all the way
gt; to c455