expressing a cell from another reference

[paramnayak]

is it possible to express a cell ,say a2, by using a1 only.

eg if i want a2+b1-c1 , i can write as... a(1+1)+b1-c1.


kindly help

 

[NARAYANK991]

Hi Nayak ,


In Excel , any cell address can be expressed in terms of another cell address , but not in the way you have indicated. A function called OFFSET is used for this purpose ; check out its help in Excel.


For instance , if you write the formula :


=OFFSET($A$1,1,0)


you are accessing the contents of cell A2.


Narayan

 

[Hui]

You can also use the Indirect() function

Like:

=INDIRECT("A"&(1+1))+B1-C1

 

[paramnayak]

thanx a lot