xirr function

J

Jim

Hi,
I am using the xirr function and when I enter a large number the result
reverts to 0%. Anyone know why? Any help would be appreciated.
Thanks, Jim
 
W

Wesslan

Hi,
I am using the xirr function and when I enter a large number the result
reverts to 0%.  Anyone know why?  Any help would be appreciated.
Thanks, Jim
Click to expand...

If the number is negative (the sum of the cashflow) you need to
provide a negative guess in order for the XIRR function to work. But
not sure this is the problem you have encountered.
 
Top