One way:

=B$1-$A2+11

See "The difference between relative and absolute references" in XL Help.


In article ,
"Excel formula fix" <Excel formula
wrote:

I am trying to create a table of numbers using the formula:
=(B1-A2)+11. I want the first value to always come from Row 1 and the
second value to come from column A. Unfortunately when I copy and paste to
all the other cells in the spreadsheet the formula changes relative to the
cell location. So, when I populate C3, it takes values from C2 and B3.

Is there an easy fix for this?

Dave