source/text/scalc/01/04060106.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit cac2a5ccfd5d7197a1a1ad706bca5f0f4235a2fd
Author: Mike Kaganski <mike.kagan...@collabora.com>
Date: Fri Dec 29 12:27:36 2017 +0100
Correction to the QUOTIENT spreadsheet function documentation
If arguments have different signs, it isn't equivalent to
INT(numerator/denominator). E.g., QUOTIENT(-3,14;1) gives -3, while
INT(-3,14/1) gives -4.
Change-Id: I1abe0a6bd77ba5f451844cf3e5c2ab2e021d7c96
Reviewed-on: https://gerrit.libreoffice.org/47171
Reviewed-by: Adolfo Jayme Barrientos <fit...@ubuntu.com>
Tested-by: Adolfo Jayme Barrientos <fit...@ubuntu.com>
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index 7d49a2905..806a043a1 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -887,7 +887,7 @@
<paragraph id="hd_id3144646" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
<paragraph id="par_id3144659" role="code" xml-lang="en-US">QUOTIENT(Numerator;
Denominator)</paragraph>
<paragraph id="par_id9038972" role="paragraph" xml-lang="en-US">Returns the
integer part of <emph>Numerator</emph> divided by
<emph>Denominator</emph>.</paragraph>
-<paragraph id="par_id7985168" role="paragraph" xml-lang="en-US">QUOTIENT is
equivalent to <item type="literal">INT(numerator/denominator)</item>, except
that it may report errors with different error codes.</paragraph>
+<paragraph id="par_id7985168" role="paragraph" xml-lang="en-US">QUOTIENT is
equivalent to <item type="literal">INT(numerator/denominator)</item> for
same-sign numerator and denominator, except that it may report errors with
different error codes. More generally, it is equivalent to <item
type="literal">INT(numerator/denominator/SIGN(numerator/denominator))*SIGN(numerator/denominator)</item>.</paragraph>
<paragraph id="hd_id3144674" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
<paragraph id="par_id3144687" role="paragraph" xml-lang="en-US"><item
type="input">=QUOTIENT(11;3)</item> returns 3. The remainder of 2 is
lost.</paragraph><comment>see also MOD, INT</comment>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
