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

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

when you have written (b1... select wach cell name in turn (i.e. b1) and
press f4, then do that to A2 as well, making it an absolute cell reference.

Hi, do you want your first value to always be taken from B1, if so use $B$1,
your second figure should be $A2. this will keep your second value to be
taken from cell A but the row value will change accordingly

Hope this answers your question

Kath

"Excel formula fix" <Excel formula wrote in
message ...
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