XIRR Question

[JPBCAD]

Hello,

I am using a XIRR formula to calculate cash flows at different dates for multiple investments but for a reason that I ignore, the last investment (the 50th of many) I entered returned me a #NUM error as the IRR will be negative. But the same exact formula was used to calculate negative IRRs in the file earlier without a problem (or getting the 0.000000298% error). Why do I get a #NUM error that specific line which is the only case in the whole document?

Thanks

 

[JPBCAD]

It's fine the dates were mixed up. Other then that, you guys have any insight on the 0.000000298% error?