Quote:
Originally Posted by Colin Legg
Hi,
To enter exponentials in Excel you need to use the ^ symbol.
I've got better news for you though: Excel 2007 has a built-in worksheet function to calculate the CAGR. The function is called XIRR(). You can find more information about it in the Excel helpfile and there's an example here:
http://office.microsoft.com/en-us/ex...001122506.aspx
Hope that helps...
|
But in XIRR you need at least one minus (-) data and one positive (+) data. so how if you only have positive data?
can you help me?