XIRR Function Error

[Vince]

Hi there,

I am trying to create a sensitivity table that is driven off the XIRR
function. I get some positive values, a neg. value and mostly #NUM!. Can
someone please help?

 

[Myrna Larson]

Have you followed the "rules" for the XIRR function WRT to the first date, the
signs of the values, and the guess? They are pretty well explained in Help for
the function.