diff options
| author | Gabor Kelemen <kelemeng@gnome.hu> | 2016-11-25 11:12:32 +0100 |
|---|---|---|
| committer | Andras Timar <andras.timar@collabora.com> | 2016-11-26 18:19:55 +0000 |
| commit | 67f77ad0e414cfc4d08b821944616f5b819ac774 (patch) | |
| tree | 68b77c037ce9c66bb75f5f8a8a2bd6a08addb8a2 /source/text/scalc/01/04060119.xhp | |
| parent | fad1d9b854420d35adec033b26e0e5d90a4f7725 (diff) | |
tdf#103241 Link XIRR and IRR as well as XNPV and NPV to each other
Change-Id: I3a2697d8a71d78042721ff963476e4f592cb7e62
Reviewed-on: https://gerrit.libreoffice.org/31191
Reviewed-by: Andras Timar <andras.timar@collabora.com>
Tested-by: Andras Timar <andras.timar@collabora.com>
Diffstat (limited to 'source/text/scalc/01/04060119.xhp')
| -rw-r--r-- | source/text/scalc/01/04060119.xhp | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/source/text/scalc/01/04060119.xhp b/source/text/scalc/01/04060119.xhp index d2301cf82f..e6fb3356b9 100644 --- a/source/text/scalc/01/04060119.xhp +++ b/source/text/scalc/01/04060119.xhp @@ -328,7 +328,9 @@ </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_NBW" id="bm_id3148417" localize="false"/> <paragraph role="heading" id="hd_id3149242" xml-lang="en-US" level="2" l10n="U" oldref="301">NPV</paragraph> -<paragraph role="paragraph" id="par_id3145308" xml-lang="en-US" l10n="CHG" oldref="302"><ahelp hid="HID_FUNC_NBW">Returns the present value of an investment based on a series of periodic cash flows and a discount rate. To get the net present value, subtract the cost of the project (the initial cash flow at time zero) from the returned value.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3145308" xml-lang="en-US"><ahelp hid="HID_FUNC_NBW">Returns the present value of an investment based on a series of periodic cash flows and a discount rate. To get the net present value, subtract the cost of the project (the initial cash flow at time zero) from the returned value.</ahelp></paragraph> +<paragraph id="par_idN111381" role="paragraph" xml-lang="en-US">If the payments take place at irregular intervals, use the <link href="text/text/scalc/01/04060118.xhp#xnpv" name="XNPV">XNPV</link> function.</paragraph> + <paragraph role="heading" id="hd_id3149937" xml-lang="en-US" level="3" l10n="U" oldref="303">Syntax</paragraph> <paragraph role="code" id="par_id3153321" xml-lang="en-US" l10n="U" oldref="304">NPV(Rate; Value1; Value2; ...)</paragraph> <paragraph role="paragraph" id="par_id3150630" xml-lang="en-US" l10n="U" oldref="305"> |