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!

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

"Mike" wrote:

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!

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?

"jnu" wrote:

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

"Mike" wrote:

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!

Try

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Mike" wrote in message
...
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?

"jnu" wrote:

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

"Mike" wrote:

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!

That WORKED! Thank you!

"Bob Phillips" wrote:

Try

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Mike" wrote in message
...
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?

"jnu" wrote:

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

"Mike" wrote:

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!