FORMULAR REDIRECT

  • Thread starter Thread starter Kanmi
  • Start date Start date
K

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
 
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)
 
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
 
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.
 
Delete the heading, drag your formula down from E1:E135

Overwrite the fomula in E2 with your heading.


Gord Dibben MS Excel MVP
 
Back
Top