Adding constant to column of numbers
Posted by Joan L. on January 14, 2002 11:15 AM
Is there a way to add a constant to a column of numbers, without creating a separate column to do so?
In other words, at the end of each quarter, I want to add a constant number to all the amounts in a single column. What comes to mind is to insert a column, and create the formula in B1: =A1 + X, and copy it down. (A1 being the first cell with the amount I want to add the constant X to.) Then eliminate the first column (A), leaving the second column (B) in its place with the amounts I need.
Is there another more efficient way to just add a constant to all the numbers in the column, in the first place?
THANKS (as usual)!