Dear all
I need a help. I want to drag this formula down to get the value.
=I3-('[Share Returns and Market Returns Main file.xlsx]Alpha and Beta'!$B$3+'[Share Returns and Market Returns Main file.xlsx]Alpha and Beta'!$B$4*U3)
However, I would like to change the formula
=D4-('[Share Returns and Market Returns Main file.xlsx]Alpha and Beta'!$C$3+'[Share Returns and Market Returns Main file.xlsx]Alpha and Beta'!$C$4*P4)
=D5-('[Share Returns and Market Returns Main file.xlsx]Alpha and Beta'!$D$3+'[Share Returns and Market Returns Main file.xlsx]Alpha and Beta'!$D$4*P5)
When I drag down, want the cell to be changed from B to C to D. Please help me.
Regards
Shams
Bookmarks