naming formula

[R.VENKATARAMAN]

In naming formulas if the formula contains a cell address this address is
taken as absolute address in the orginal formula. On the other hand if the
formula(not the name) is copied into a new cell the cell addresses of the
formula are relative. can I not use formula name to show relative addresses.
I tried using R1C1 style . that also does not help.

I hope my doubt is clear.

 

[Dave Peterson]

I made a name (testFormula) that refered to this formula:
=Sheet1!$D$12+Sheet1!$A$1

and when I put =testformula anywhere, I got what "=Sheet1!$D$12+Sheet1!$A$1"
evaluated to.

I think you want to use relative addresses in your defined name.

For instance, if I select B12 and insert a name (testformula2) with this
formula:

=Sheet1!A1+Sheet1!C13

Then if I go to x99 and type =testformula2, it'll refer to W88 & Y100 (the same
relative positions as how I defined it).

 

[R.VENKATARAMAN]

thank you lot for clairfying . I think where I did the mistake was

I place a formula in c1 as =a1+b1
then I gave a name to C1. that is the mistake


I should keep the cursor at C1. then
I shoud click insertname-define
name of formula is "formulaone"
in the refefence I should type <=a1+b1>
then this name will work.

if you keep the cursor anywhere and name for the formula and reference any
formula the name will take the same relative positions
for e.g. if I keep the cursor in C4 and refernce a formula whose name is
"formulatwo" and reference is a1+b1 that means it adds offset postions 3
above and two left +3 above and one left.
(this is just to clarify to myself)
thanks for clarification.