Formulas

[Guest]

I'm trying to find a function that will allow me to insert columns without
Excel changing my formulas in adjacent columns. For example, I have a
formula in cell A1 that calculates the refennce in cell B1 and C1. When I
insert a new column between A & B I still want my formula in cell A1 the
calculate using B1 and C1. I'm probably overlooking a simple solution. Can
anyone help me with this? Thanks!

 

[Guest]

before you insert column change formula to a $b$1 abd $c$1

 

[Guest]

I tried using the absolute function ($) in my formula, however, when I insert
a new column my formula changes. For example, my formula in cell A1 is
=B1-C1 (or =$B$1-$C$1 as you suggested), but when I insert a column between A
and B, my formula in A1 changes to =C1-D1 (or =$C$1-$D$1). How do I keep my
formula intact when inserting a column?

 

[Bob Phillips]

Try

=INDIRECT("B1")-INDIRECT("C1")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Guest]

That WORKED! Thank you!

Try

=INDIRECT("B1")-INDIRECT("C1")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)