Excel Merge Formula Question

[tektipuser2005]

Hi All,

I have three columns, column A, B, and C:
20 5 15
4 -4
3 -3
2 -2
1 -1
4 -4
5 -5
6 -6
7 -7
8 -8

Column A with value of 20 is merged. Column C has a formula like =A1-B1 and then I drag that down. However, after dragging it down it does not copy the correct formula, it will imput =A2-B2, A3-B3, etc. I would like to always keep the value =A1-XX, =A1-XX, =A1-XX, etc.

Thank you for your input.

 

[Lilliabeth]

Column A with value of 20 is merged

What do you mean?

Is this what you want?

=$A$1-B1

 

[tektipuser2005]

Yes, that's it! Thanks...