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