Hi! Excel programmers,I have a problem with cells.

Problem
I have a formula in cell A1 which is B1*C1,problem is if i
select lets say column B and insert a column, the formula
in cell A1 changes to C1*D1 and which is not what i want.I
would like to make this formula to stay constant even i
add columns.

Thanks a lot, your help it is highly appreciated.

Mpho

use the INDIRECT function

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



-----Original Message-----
Hi! Excel programmers,I have a problem with cells.

Problem
I have a formula in cell A1 which is B1*C1,problem is if
i
select lets say column B and insert a column, the
formula
in cell A1 changes to C1*D1 and which is not what i
want.I
would like to make this formula to stay constant even i
add columns.

Thanks a lot, your help it is highly appreciated.

Mpho

.

Try this

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mpho" wrote in message
...
Hi! Excel programmers,I have a problem with cells.

Problem
I have a formula in cell A1 which is B1*C1,problem is if i
select lets say column B and insert a column, the formula
in cell A1 changes to C1*D1 and which is not what i want.I
would like to make this formula to stay constant even i
add columns.

Thanks a lot, your help it is highly appreciated.

Mpho