Excel 2007 : is it possible to express a cell, say a2, using only a1

[paramnayak]

is it possible to express a cell, say a2, using only a1
eg if i want a2+b1-c1 , i can express this as say a(1+1)+b1-c1

[NickyC]

why not use offset?

[SCLai]

Welcome to the forums

Sorry, but I don't really get your question...
Can you please elaborate if none of the below is what you are looking for?
=INDEX(A:A,ROW()+1)+B1-C1
=OFFSET(A1,1,0)+B1-C1

Hope this is what you wanted!

SC

[paramnayak]

thanx. offset is working fine as i can drag the formula. thanx a lot