Fixed Columns
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
|