Fix cell in formula

[dennis5452]

A2*B2 A2 - A10 - B2 is a 1 cell variable can I wrap b2 in a container so it will not incriment when I copy the formula to the 9 "a" cells.

Example:
A3*b3 I want B to always point to B2
A4*b4
A5*b5
like this
A3*b2
A4*b2
A5*b2

 

[Ian]

I'm not sure if I understand you, but if you are trying to write a formula with a fixed cell (even when copied and pasted) you need to type in $B$2 rather than B2.

 

[dennis5452]

That did it, Tahnk you very much. I tried every container I could think of.

Thanks again

Dennis5452