View Single Post
  #2   Report Post  
Otto Moehrbach
 
Posts: n/a
Default

If I understand you correctly, you will need 3 cells. One cell, say A1, is
the cell that never changes. The second cell, say B1, is the cell into
which you type a number. The third cell, say C1, is the cell that has the
answer of the second cell subtracted from the first cell. In the third cell
type:
=A1-B1
HTH Otto
"PghPatti" wrote in message
...
I'm new and trying to learn Excel so please excuse the simple questions. I
want to create a formula on a spread sheet that will subtract the number
that
I will put in a new cell every month from a cell that never changes. This
cell - with the answer - sits below the spreadsheet.

PghPatti