FORMULAR REDIRECT

[Kanmi]

Hello, Please can anybody help me with this.

i want to put this formular on cell "E1" (=365/(M3/N3) and i want the
formular to apply to FROM "E3:E135". I want the formular to be on E1.

Please how can i go about this. God bless you as you take your time to ans
this. Thanks

 

[cm]

If you copy the formula down column E as it is, the cell references will
change for M and N. If you do not want that, and all the values in Column E
should be the same, then E1 should read:
=365/($M$3/$N$3)

 

[Jacob Skaria]

You can place the 3 components in 3 cells and try
F1 = 365
F2 = M3
F3 = N3

=F1/(INDIRECT(F2)/INDIRECT(F3))

or you can try the below so as to adjust the row number for E3:E135".

F1 = 365
F2 = M
F3 = N

=365/(INDIRECT($F$2 & ROW())/INDIRECT($F$3 & ROW()))

If this post helps click Yes

 

[Sean Timmons]

so you want cell E1 to be the formula and you wangt E3 to E135 to have the
value in this formula. You can either has E3 to E135 show =E$1 or you can
check in with the programming folks on a macro.

 

[Gord Dibben]

Delete the heading, drag your formula down from E1:E135

Overwrite the fomula in E2 with your heading.


Gord Dibben MS Excel MVP