CAGR

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Did you look at Help for this function? It tells you what that result means
and what to do about it.
 
Back
Top