Absolute cell formula

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
P

Phil Hageman

Case One Case Two
A B C D A B C D
1 =C1 3 1 =C1 5 3

In Case One, the value for B1 is 3. When a new column C
is inserted (Case Two), the formula in B1 is automatically
changed to =D1, and the value remains 3. Is there a way
to write the formula so it retains the intent of =C1 after
the new column is inserted - such that the value in B1
would now equal 5?
=$C$1 doesn't work - it too changes to =$D$1.
Thanks,
Phil
 
Phil,

Try

=INDIRECT("C1")

--

HTH

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

=INDIRECT("C1")

will do the job.

--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.
 
Thanks, Bob - it works!
-----Original Message-----
Phil,

Try

=INDIRECT("C1")

--

HTH

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




.
Click to expand...
 
Back
Top