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