If you hit F4 in the formula or type $ before the letter and cell number for
the cell that never changes and it will create an absolute value for that
cell. You can copy that formula and the value of that cell in the formula
will not change. =$A$1*B1

"PghPatti" wrote:

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