Hi,
XNPV, the invers function to XIRR, also appears to be affected in a similar
way. Calculating the Net Present Value based on
the rate calculated by XIRR, a rate of 0% and 13.0662% all result in 7.25E-322
as a NPV (displayed as 0). I would
have expected that only 13.0662% (or maybe the XIRR result) yield 0.
Addition to xirr-demo1-amd64:
table:formula="oooc:=com.sun.star.sheet.addin.Analysis.getXnpv(0;[.B1:.B3];[.A1:.A3])"
office:value-type="float"
office:value="7.25E-322">
<text:p>0</text:p>
table:formula="oooc:=com.sun.star.sheet.addin.Analysis.getXnpv([.B5];[.B1:.B3];[.A1:.A3])"
office:value-type="float"
office:value="7.25E-322">
<text:p>0</text:p>
table:formula="oooc:=com.sun.star.sheet.addin.Analysis.getXnpv(0.130662;[.B1:.B3];[.A1:.A3])"
office:value-type="float"
office:value="7.25E-322">
<text:p>0</text:p>
Kai
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
