If D is the column, In the column where you would like the new values output enter the formula =a1+$D$1 and copy down the column. Now whatever value you put in D1 will be added to the values in column A. if you want to subtract, just enter -1 into D1.
|