Help with Absolute formulars 1

[mosmas]

I have a function in cell A2, let's say =($D$2/$C$2)*$C$2in my spreasheet, which work great.Here is my problem, if I insert an column before column B, my formula changes to =($C$2/$D$2)*$D$2. Is there any way I have the formula stay as =($D$2/$C$2)*$C$2 after insterting a column before the referenced cells.

Please advise.

Mosmas

 

[SkipVought]

Hi,

Well the values that were in d2 & c2 are now in e2 and d2 respectively

Why are you trying to accomplish by inserting the column?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[KenWright]

Are you sure you don't mean it changes to:-

=($E$2/$D$2)*$D$2 and not
=($C$2/$D$2)*$D$2

That having been said, the easiest way is to use the INDIRECT function, eg:-

=INDIRECT("$D$2&quot/INDIRECT("$C$2&quot*INDIRECT("$C$2&quot

BUT, if the formula you have given is the real formula, it can simply be rewritten as:-

=INDIRECT("$D$2&quot

as dividing by C2 and then multiplying by C2, obviously bring you back to where you started, which was D2.

Regards
Ken.....................

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------

 

[mosmas]

Ken:

Thanks a lot.. and as for the formula, that was just for demonstration purposes. Thanks, It worked like a champ.

mosmas

 

[KenWright]

OK, glad you got sorted - The formula kind of threw me when I thought it wasn't doing anything. Appreciate the feedback.

Regards
Ken..................

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------