FORMULAR REDIRECT
 

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

FORMULAR REDIRECT
 

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)


"Kanmi" wrote:

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

FORMULAR REDIRECT
 

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
---------------
Jacob Skaria


"Kanmi" wrote:

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

FORMULAR REDIRECT
 

oh thanks alot. There is no way i can drag it down. on E2 i have heading and
i don't want the formular to be showing when i click on E3:E135. PLEASE HELP

"cm" wrote:

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)


"Kanmi" wrote:

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

FORMULAR REDIRECT
 

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.

"Kanmi" wrote:

oh thanks alot. There is no way i can drag it down. on E2 i have heading and
i don't want the formular to be showing when i click on E3:E135. PLEASE HELP

"cm" wrote:

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)


"Kanmi" wrote:

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

FORMULAR REDIRECT
 

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

Overwrite the fomula in E2 with your heading.


Gord Dibben MS Excel MVP

On Mon, 28 Sep 2009 10:10:02 -0700, Kanmi
wrote:

oh thanks alot. There is no way i can drag it down. on E2 i have heading and
i don't want the formular to be showing when i click on E3:E135. PLEASE HELP

"cm" wrote:

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)


"Kanmi" wrote:

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