View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CM CM is offline
external usenet poster
 
Posts: 136
Default 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