how do you add a new number to each cell in a column
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.
"JCE" wrote:
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
|