software

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 amp; 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

quot;Mikequot; wrote:

gt; I'm trying to find a function that will allow me to insert columns without
gt; Excel changing my formulas in adjacent columns. For example, I have a
gt; formula in cell A1 that calculates the refennce in cell B1 and C1. When I
gt; insert a new column between A amp; B I still want my formula in cell A1 the
gt; calculate using B1 and C1. I'm probably overlooking a simple solution. Can
gt; 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?

quot;jnuquot; wrote:

gt; before you insert column change formula to a $b$1 abd $c$1
gt;
gt; quot;Mikequot; wrote:
gt;
gt; gt; I'm trying to find a function that will allow me to insert columns without
gt; gt; Excel changing my formulas in adjacent columns. For example, I have a
gt; gt; formula in cell A1 that calculates the refennce in cell B1 and C1. When I
gt; gt; insert a new column between A amp; B I still want my formula in cell A1 the
gt; gt; calculate using B1 and C1. I'm probably overlooking a simple solution. Can
gt; gt; anyone help me with this? Thanks!

Try

=INDIRECT(quot;B1quot;)-INDIRECT(quot;C1quot;)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Mikequot; gt; wrote in message
...
gt; I tried using the absolute function ($) in my formula, however, when I
insert
gt; a new column my formula changes. For example, my formula in cell A1 is
gt; =B1-C1 (or =$B$1-$C$1 as you suggested), but when I insert a column
between A
gt; and B, my formula in A1 changes to =C1-D1 (or =$C$1-$D$1). How do I keep
my
gt; formula intact when inserting a column?
gt;
gt; quot;jnuquot; wrote:
gt;
gt; gt; before you insert column change formula to a $b$1 abd $c$1
gt; gt;
gt; gt; quot;Mikequot; wrote:
gt; gt;
gt; gt; gt; I'm trying to find a function that will allow me to insert columns
without
gt; gt; gt; Excel changing my formulas in adjacent columns. For example, I have a
gt; gt; gt; formula in cell A1 that calculates the refennce in cell B1 and C1.
When I
gt; gt; gt; insert a new column between A amp; B I still want my formula in cell A1
the
gt; gt; gt; calculate using B1 and C1. I'm probably overlooking a simple
solution. Can
gt; gt; gt; anyone help me with this? Thanks!
That WORKED! Thank you!

quot;Bob Phillipsquot; wrote:

gt; Try
gt;
gt; =INDIRECT(quot;B1quot;)-INDIRECT(quot;C1quot;)
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;Mikequot; gt; wrote in message
gt; ...
gt; gt; I tried using the absolute function ($) in my formula, however, when I
gt; insert
gt; gt; a new column my formula changes. For example, my formula in cell A1 is
gt; gt; =B1-C1 (or =$B$1-$C$1 as you suggested), but when I insert a column
gt; between A
gt; gt; and B, my formula in A1 changes to =C1-D1 (or =$C$1-$D$1). How do I keep
gt; my
gt; gt; formula intact when inserting a column?
gt; gt;
gt; gt; quot;jnuquot; wrote:
gt; gt;
gt; gt; gt; before you insert column change formula to a $b$1 abd $c$1
gt; gt; gt;
gt; gt; gt; quot;Mikequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I'm trying to find a function that will allow me to insert columns
gt; without
gt; gt; gt; gt; Excel changing my formulas in adjacent columns. For example, I have a
gt; gt; gt; gt; formula in cell A1 that calculates the refennce in cell B1 and C1.
gt; When I
gt; gt; gt; gt; insert a new column between A amp; B I still want my formula in cell A1
gt; the
gt; gt; gt; gt; calculate using B1 and C1. I'm probably overlooking a simple
gt; solution. Can
gt; gt; gt; gt; anyone help me with this? Thanks!
gt;
gt;
gt;