View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
txsharla txsharla is offline
external usenet poster
 
Posts: 4
Default Product formula help

I want to mathmatically link a column of monthly returns (percentages) like
this:

(1+b2)*(1+b3)*(1+b4)*(1+b5)-1 (where b2=3.05%, b3=2.54% etc...)

I know there are other ways of doing this longhand but I'm looking for the
formula to simpifly my work. Thanks!