CAGR

M

Mike

I am trying to calculate CAGR by using the suggested fromula XIRR but contnue
to get #NAME? as an answer and not the xx%. Is this formula correct?
 
G

Gord Dibben

Mike

XIRR is from the Analysis Toolpak add-in.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

Check out Tools>Add-ins for the ATP and checkmark it.


Gord Dibben Excel MVP
 
M

Myrna Larson

Did you look at Help for this function? It tells you what that result means
and what to do about it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I calculate CAGR other than using XIRR function? 2
How to get compound annual growth rates in pivot tables. 2
xirr function 1
formulas 8
Cost increase rate 3
how do i calculate CAGR for a series of years of revenues? 1
Calculate value at the end of nth year using CAGR 4
Additional column formula in pivot table 0

Top