diff options
| author | Steve Fanning <stevemfanning.wh@gmail.com> | 2020-04-12 22:34:19 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-04-13 03:41:29 +0200 |
| commit | f8cd9798934f2cb336b09990c6d2f84a6cadcc36 (patch) | |
| tree | ac259204d22ba9a4b03f8312ae1f0bc2ce2cb690 /source/text/scalc/01/func_floor.xhp | |
| parent | 3 Basic syntax diagrams (diff) | |
| download | help-f8cd9798934f2cb336b09990c6d2f84a6cadcc36.tar.gz help-f8cd9798934f2cb336b09990c6d2f84a6cadcc36.zip | |
tdf#131960 Clarification of FLOOR/CEILING functions
Change-Id: Ifb90e95d632f0305d15562e9732dac7e3dc6d6ca
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92097
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/func_floor.xhp')
| -rw-r--r-- | source/text/scalc/01/func_floor.xhp | 26 |
1 files changed, 17 insertions, 9 deletions
diff --git a/source/text/scalc/01/func_floor.xhp b/source/text/scalc/01/func_floor.xhp index e56c0598b7..3d7e738e5b 100644 --- a/source/text/scalc/01/func_floor.xhp +++ b/source/text/scalc/01/func_floor.xhp @@ -8,7 +8,6 @@ * file, You can obtain one at http://mozilla.org/MPL/2.0/. * --> - <meta> <topic id="scalcfloorfunctions" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">FLOOR Functions</title> @@ -17,15 +16,14 @@ </meta> <body> <h1 id="hd_id391586285373874">FLOOR Functions</h1> - - <section id="Section9"> + <section id="floor"> <bookmark xml-lang="en-US" branch="index" id="bm_id3157404"> <bookmark_value>FLOOR function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value> </bookmark> <comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_UNTERGRENZE" id="bm_id3157415" localize="false"/> - <h2 id="hd_id3157404">FLOOR</h2> + <h2 id="hd_id3157404"><variable id="FLOORh1"><link href="text/scalc/01/func_floor.xhp#floor" name="FLOOR">FLOOR</link></variable></h2> <paragraph id="par_id3157432" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_UNTERGRENZE">Rounds a number to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id661586285977707">For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs.</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> @@ -52,15 +50,16 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id811586290952465"> <bookmark_value>FLOOR.MATH function</bookmark_value> </bookmark> - <h2 id="hd_id1001586287279297">FLOOR.MATH</h2> +<h2 id="hd_id1001586287279297"><variable id="FLOOR.MATHh1"><link href="text/scalc/01/func_floor.xhp#floormath" name="FLOOR.MATH">FLOOR.MATH</link></variable></h2> <paragraph role="paragraph" id="par_id721586287302689">Rounds a number to the nearest multiple of a significance value.</paragraph> <paragraph role="paragraph" id="par_id311586287323417">For a positive number the function rounds down (towards zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored.</paragraph> + <embed href="text/scalc/00/avail_release.xhp#5.0"/> + <warning id="par_id851586287535879">This function exists for interoperability with Microsoft Excel 2013 or newer.</warning> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id161586287421523">FLOOR.MATH(Number[; Significance[; Mode]])</paragraph> <embed href="text/scalc/01/func_floor.xhp#argnumber"/> <paragraph role="paragraph" id="par_id231586287448716"><emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1.</paragraph> <paragraph role="paragraph" id="par_id261586287494401"><emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded up (towards zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded down (away from zero).</paragraph> - <warning id="par_id851586287535879">This function exists for interoperability with Microsoft Excel 2013 or newer.</warning> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id101586287621816"><input>=FLOOR.MATH(3.45)</input> returns 3.</paragraph> <paragraph role="paragraph" id="par_id771586287627784"><input>=FLOOR.MATH(3.45,-3)</input> returns 3.</paragraph> @@ -69,7 +68,7 @@ <paragraph role="paragraph" id="par_id371586287641888"><input>=FLOOR.MATH(-45.67,+2, 1)</input> returns -44.</paragraph> </section> - <section id="Section9.1"> + <section id="floorprecise"> <bookmark xml-lang="en-US" branch="index" id="bm_id2957404"> <bookmark_value>FLOOR.PRECISE function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value> @@ -78,8 +77,9 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FLOOR_MS" id="bm_id2957415" localize="false"/> <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FLOOR_PRECISE" id="bm_id2957215" localize="false"/> - <h2 id="hd_id2957404">FLOOR.PRECISE</h2> + <h2 id="hd_id2957404"><variable id="FLOOR.PRECISEh1"><link href="text/scalc/01/func_floor.xhp#floorprecise" name="FLOOR.PRECISE">FLOOR.PRECISE</link></variable></h2> <paragraph id="par_id2957432" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FLOOR_MS">Rounds a number down to the nearest multiple of a significance value.</ahelp></paragraph> + <paragraph role="paragraph" id="par_id261586641501175">For a positive number the function rounds down (towards zero). For a negative number, the function rounds down (away form zero). The sign of the significance value is ignored.</paragraph> <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2957464" role="code" xml-lang="en-US">FLOOR.PRECISE(Number[; Significance])</paragraph> @@ -96,9 +96,10 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id171586291849333"> <bookmark_value>FLOOR.XCL function</bookmark_value> </bookmark> - <h2 id="hd_id791586291468176">FLOOR.XCL</h2> +<h2 id="hd_id791586291468176"><variable id="FLOOR.XCLh1"><link href="text/scalc/01/func_floor.xhp#floorxcl" name="FLOOR.XCL">FLOOR.XCL</link></variable></h2> <paragraph role="paragraph" id="par_id521586291476023">Rounds a number to the nearest multiple of a significance value.</paragraph> <paragraph role="paragraph" id="par_id401586291488768">For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a positive significance value, the function rounds down (away from zero). For a negative number and a negative significance value, the function rounds up (towards zero). The function returns an error if the number is positive and the significance value is negative.</paragraph> + <embed href="text/scalc/00/avail_release.xhp#5.0"/> <warning id="par_id231586291503319">This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s FLOOR.XCL function are exported as references to Excel’s FLOOR function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s FLOOR function are imported as references to Calc’s FLOOR.XCL function.</warning> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id491586291532177">FLOOR.XCL(Number; Significance)</paragraph> @@ -109,5 +110,12 @@ <paragraph role="paragraph" id="par_id361586291628003"><input>=FLOOR.XCL(-45.67,2)</input> returns -46.</paragraph> <paragraph role="paragraph" id="par_id801586291641099"><input>=FLOOR.XCL(-45.67,-2)</input> returns -44.</paragraph> </section> + <section id="relatedtopics"> + <embed href="text/scalc/01/func_ceiling.xhp#CEILINGh1"/> + <embed href="text/scalc/01/func_ceiling.xhp#CEILING.MATHh1"/> + <embed href="text/scalc/01/func_ceiling.xhp#CEILING.PRECISEh1"/> + <embed href="text/scalc/01/func_ceiling.xhp#CEILING.XCLh1"/> + <embed href="text/scalc/01/func_ceiling.xhp#ISO.CEILINGh1"/> + </section> </body> </helpdocument> |