diff options
Diffstat (limited to 'source/text/scalc/01/04060106.xhp')
| -rw-r--r-- | source/text/scalc/01/04060106.xhp | 50 |
1 files changed, 0 insertions, 50 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 0bd8172ee0..36bde5f4d1 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1420,56 +1420,6 @@ <paragraph id="par_id5675527" role="paragraph" xml-lang="en-US"><item type="input">=ODD(-3.1)</item> returns -5.</paragraph><comment>see also CEILING, FLOOR, EVEN, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> </section> -<section id="Section9.1"> -<bookmark xml-lang="en-US" branch="index" id="bm_id2957404"> - <bookmark_value>FLOOR.PRECISE function</bookmark_value> - <bookmark_value>FLOOR.XCL 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_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> -<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 Significance, regardless of sign of Significance</ahelp></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> -<paragraph id="par_id2957478" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded down.</paragraph> -<paragraph id="par_id2957497" role="paragraph" xml-lang="en-US"><emph>Significance</emph> is the value to whose multiple the number is to be rounded down.</paragraph> -<embed href="text/scalc/01/04060106.xhp#floor_warn"/> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id2963945" role="paragraph" xml-lang="en-US"><item type="input">=FLOOR.PRECISE( -11;-2)</item> returns -12</paragraph><comment>see also CEILING, EVEN, ODD, MROUND,INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> -</section> - -<section id="Section9"> -<bookmark xml-lang="en-US" branch="index" id="bm_id3157404"> - <bookmark_value>FLOOR function</bookmark_value> - <bookmark_value>FLOOR.MATH 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"/> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FLOOR_MATH" id="bm_id3167415" localize="false"/> - -<h2 id="hd_id3157404">FLOOR</h2> -<paragraph id="par_id3157432" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_UNTERGRENZE">Rounds a number down to the nearest multiple of Significance.</ahelp></paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3157464" role="code" xml-lang="en-US">FLOOR(Number; Significance; Mode)</paragraph> -<paragraph id="par_id3157478" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded down.</paragraph> -<paragraph id="par_id3157497" role="paragraph" xml-lang="en-US"><emph>Significance</emph> is the value to whose multiple the number is to be rounded down.</paragraph> -<paragraph id="par_id3157517" role="paragraph" xml-lang="en-US"><emph>Mode</emph> is an optional value. If the Mode value is given and not equal to zero, and if Number and Significance are negative, then rounding is done based on the absolute value of Number, i.e. negative numbers are rounded towards zero. If the Mode value is equal to zero or is not given, negative numbers are rounded away from zero.</paragraph> -<section id="floor_warn"> - <warning id="par_id3163894">If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero.</warning> -</section> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3163945" role="paragraph" xml-lang="en-US"><item type="input">=FLOOR( -11;-2)</item> returns -12</paragraph> -<paragraph id="par_id3163966" role="paragraph" xml-lang="en-US"><item type="input">=FLOOR( -11;-2;0)</item> returns -12</paragraph> -<paragraph id="par_id3163988" role="paragraph" xml-lang="en-US"><item type="input">=FLOOR( -11;-2;1)</item> returns -10</paragraph><comment>see also CEILING, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> -</section> - <section id="Section8"> <bookmark xml-lang="en-US" branch="index" id="bm_id3164086"> <bookmark_value>SIGN function</bookmark_value> |