I hit what appears to be a bug in XIRR.
I’ve spent several hours cutting it down.
I’ve created .ods with several examples.
In test5 there are 51 “values” …mostly are blank and only the values 1,100,-101 are present (so the answer should be 0%)
If you include all 51 cells the result is 2382.61% …if however you exclude the 1st value (blank or 0 … same behaviour) OR set it’s date to 1 jan 2014 (vs 1 jan 2013) it gets the correct value of 0%
xirr-tests.ods (27.1 KB)