From f52790876dae6ffe59fd71bf5f59df33678f0b5a Mon Sep 17 00:00:00 2001 From: Roman Kuznetsov Date: Mon, 22 Apr 2019 21:19:28 +0200 Subject: tdf#105848 Change EFFECTIVE function name to EFFECT Change-Id: Id2bd603a0330f1d85e665c0524635e0369061a18 Reviewed-on: https://gerrit.libreoffice.org/71079 Tested-by: Jenkins Reviewed-by: Olivier Hallot --- source/text/scalc/01/04060103.xhp | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/source/text/scalc/01/04060103.xhp b/source/text/scalc/01/04060103.xhp index 4592d9d5f0..b22e8dd066 100644 --- a/source/text/scalc/01/04060103.xhp +++ b/source/text/scalc/01/04060103.xhp @@ -588,14 +588,14 @@ annual net interest rates calculating; annual net interest rates net annual interest rates - EFFECTIVE function + EFFECT function mw added one entry -EFFECTIVE +EFFECT Returns the net annual interest rate for a nominal interest rate. Nominal interest refers to the amount of interest due at the end of a calculation period. Effective interest increases with the number of payments made. In other words, interest is often paid in installments (for example, monthly or quarterly) before the end of the calculation period. - EFFECTIVE(Nom; P) + EFFECT(Nom; P) Nom is the nominal interest. @@ -603,7 +603,7 @@ If the annual nominal interest rate is 9.75% and four interest calculation periods are defined, what is the actual interest rate (effective rate)? - =EFFECTIVE(9.75%;4) = 10.11% The annual effective rate is therefore 10.11%. + =EFFECT(9.75%;4) = 10.11% The annual effective rate is therefore 10.11%.
effective interest rates -- cgit