98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » XIRR / CAGR
XIRR / CAGR
Resolved · Medium Priority · Version 2007
Tue 10 Aug 2010, 09:45Delegate Ginger said...
Ginger has attended:
Upgrade to Office 2007 course
XIRR / CAGR
XIRR function returns #VALUE! even though I have copied the exact example from the MS help page: http://office.microsoft.com/en-gb/excel-help/xirr-HP005209341.aspx
I also checked that the Analysis Toolpak is installed.
Ultimately, I am trying to calculate CAGR for a series of positive revenue numbers, so please advise if XIRR is not the best function to use. Thanks.
Tue 10 Aug 2010, 11:33Trainer Anthony said...
RE: XIRR / CAGR
Hi Ginger, thanks for your query. Check whether your source data is correctly formatted. If your numbers are formatted as text the function won't work correctly. It sounds like you're pasting it directly onto an unformatted spreadsheet which has the default "General" formatting. Note also, that example applies to Excel 2003. Have a read of this:
http://excel.tips.net/Pages/T002503_Using_the_XIRR_Function.html
Also, if you're after a CAGR calculator have a look at this:
http://www.experiglot.com/2006/01/28/compound-annual-growth-rate-cagr-calculator-xls/
Hope this helps,
Anthony
Tue 17 Aug 2010: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Currency formatCtrl+Shift+$ applies the Currency format, with two decimal places |
