View Single Post
  #10   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
Howard Kaikow Howard Kaikow is offline
external usenet poster
 
Posts: 269
Default Corrupt XIRR formula

As pointed out by Jerry and Ron, if I include a guess in the XIRR, then I
get the expected result.
But, in the general case, there is no way for a user to know what to guess.

Excel 2003's Help states:

"In most cases you do not need to provide guess for the XIRR calculation. If
omitted, guess is assumed to be 0.1 (10 percent)."

If I use a guess of -.1, I get the expected result.

What do folkes think about using the following as a guess:

=XIRR(B3:B44, A3:A44, SIGN(SUM(B3:B44)) * .1)