Absolute Cell Addressing

sadia

New member
Joined
Jan 26, 2013
Messages
14
Reaction score
0
Points
0
SALAM
Hi Every one Hope that all of you are fine.

How i can use this formula to have the absolute cell address.
=(ADDRESS(ROW()-1,COLUMN()))
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
That is the absolute cell address.
 

sadia

New member
Joined
Jan 26, 2013
Messages
14
Reaction score
0
Points
0
when one uses this function =INDIRECT(ADDRESS(ROW()-5,COLUMN())) and copy this down this is using relative cell addressing.
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
That is a different question.

So you want a lot of cells to all reference F1? Why not just use =INDIRECT($F$1) in them all?
 

sadia

New member
Joined
Jan 26, 2013
Messages
14
Reaction score
0
Points
0
actually i am trying to fill the missing values (my last post) in the forum. If the last 5 values are missing for any indiviual , i have to fill them. the formula to fill these values is given in column E49 and so on . as i have 65 variables and 84 indiviulas . so i will have to do a lot editing. to aviod tthis i am using the formula in column D see cell D49. but the issue with this formula is that it is using relative cell addressing.

((End Value/Start Value)^(1/(Periods - 1)) -1) must be fixed
 

Attachments

  • Cell reference .xlsx
    12.6 KB · Views: 19

Battyone

New member
Joined
Jan 30, 2013
Messages
1
Reaction score
0
Points
0
=IF(ISBLANK(INDIRECT((ADDRESS(ROW()-1,COLUMN(),1,1)))),123,321)

worked for me for copying down.

*EDIT -- then again I'd generally do a task like this in VBA.
 
Top