simple formula

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

If in column A1 I have a value of 806.38 and I want to subtract 29.31 all the
way down column A without showing the number 29.31 anywhere but MAYBE A2 if
necessary. How would I write this formula. Thanks.
 
in cell A2, type =a1-29.31, then copy that formula down the column as far as
needed. (cell A3 will actually bump the cell reference to =a2-29.31, and so
on).
 
I'm assuming you want to physically change the values in Column A (that is,
they won't contain their original values afterwards). Enter 29.31 in A1,
then press Ctrl+C, select all the values you want to change, click
Edit/PasteSpecial on Excel's menu bar, click the Subtract option button and
press OK. Finally, press Esc to clear the copy's source selection and click
somewhere to remove the destination selection.

Rick
 
Back
Top