View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron George Ron George is offline
external usenet poster
 
Posts: 7
Default Code for sigma of product involving exponential - help

Hi all,

Could any guru help me with the following problem.



The formula I want to implement is :

f(n) = k1 x Sigma [w(i) x exp(-n-i)/tau1] where i goes from 1 to n-1.

n are my days that are arranged in a column C.

w(i) are rows in column C and the formula f (n) needs to go into rows of colmumn E.

Some more specifics of the problem with an image of my spreadsheet was described here : https://stackoverflow.com/questions/...27055#50027055


Appreciate any help implementing an elegant code, thanks.