Easy formula Question

[Guest]

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

 

[JE McGimpsey]

One way:

=B$1-$A2+11

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

 

[Guest]

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.

 

[kathleen.smith10]

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