Thread: xirr function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
john
 
Posts: n/a
Default xirr function

If the data is organized as follows, how do I adjust the XIRR formula (or
format of the data) to produce a CAGR ?

2008 2009 2010
NS 100 200 350

Must the year row include m/d/y format only ?

Thanks,