Formulas
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!
|