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

On Wed, 23 Mar 2005 05:55:04 -0800, "Mike"
wrote:

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?