FORMULAR REDIRECT

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
 
C

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)
 
J

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
 
S

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top