Fixed Columns

[Mpho]

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

 

[Patrick Molloy]

use the INDIRECT function

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

 

[Bob Phillips]

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)