=NPV(0,0875;{10;20;30}) throws error in Calc, return result in Excel. ODF spec: 6.12.30NPV *Summary:* Compute the net present value (NPV) for a series of periodic cash flows. *Syntax:* NPV( /Number/ Rate ; { /NumberSequenceList/ Value } + )
https://help.libreoffice.org/5.1/Calc/Financial_Functions_Part_Two#NPV --> =NPV(0,0875;10;20;30) works Same for Excel: =NPV(0,0875;{10;20;30}) does not work here (Excel 2013)
@raal: the spec is nothing saying about brackets. This is the annotation that there can be inserted multiple values in that formula. see the helpwiki link
sry for the noise. CONFIRMED: Arrays are really not yet integrated in Calc.
Be careful with the separators, =NPV(0.0875,{10,20,30}) or =NPV(0.0875,{10;20;30}) work in Excel.
Will add support for array arguments.
Winfried Donkers committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e4b3772ef966fb3db8dfaa55dfc5f5582d61761d tdf#100762 Add support for array arguments to NPV. It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.