diff options
| author | Mike Kaganski <mike.kaganski@collabora.com> | 2017-12-29 12:27:36 +0100 |
|---|---|---|
| committer | Adolfo Jayme Barrientos <fitojb@ubuntu.com> | 2017-12-29 20:42:34 +0100 |
| commit | cac2a5ccfd5d7197a1a1ad706bca5f0f4235a2fd (patch) | |
| tree | 6cb3cd0978cb305eacd616d32217cf6cb4425d5b /source/text/scalc/01 | |
| parent | 50b850013374e0f711b5cded92739934d758bf1f (diff) | |
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 <fitojb@ubuntu.com>
Tested-by: Adolfo Jayme Barrientos <fitojb@ubuntu.com>
Diffstat (limited to 'source/text/scalc/01')
| -rw-r--r-- | source/text/scalc/01/04060106.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 7d49a29059..806a043a1e 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> |