Locking formulas in cells

[Zeina Dahdouh]

Hello,

I have a problem with locking a formula in a cell. For
example: A1 and B1 contain numbers and C1
contains: "=A1*B2".
I want to lock it so i make the formula in C1: "A$1*B$1"
BUT when i cut A1 and B1 and paste them into A2 and B2,
the formula in C1 will change to: "A$2*B$2"

How do I get cell C1 to stay "A$1*B$1" when i cut cells A1
and B1 and move them?

Thank you

 

[J.E. McGimpsey]

One way, of many:

C1: =INDIRECT("A1")*INDIRECT("B1")

another:

C1: =OFFSET(C1,0,-2)*OFFSET(C1,0,-1)

a third:

C1: =PRODUCT(INDIRECT("A1:B1"))

a fourth:

C1: =PRODUCT(OFFSET(C1,0,-2,1,2))