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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number Format? 3
Corrupt XIRR formula 10
XIRR Function Using Months Instead of Years 9
Why Doesn't XIRR work? 2
XIRR question 5
Can XIRR start with a "0" in the first period 4
How to write XIRR formula on excel using different Year basis than 365. 5
XIRR Function in Access 16

Top