diff options
| -rw-r--r-- | source/text/scalc/01/04060106.xhp | 10 | ||||
| -rw-r--r-- | source/text/scalc/01/func_networkdays.xhp | 1 |
2 files changed, 9 insertions, 2 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index b56ed3cda7..a5d890e09d 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -1538,10 +1538,12 @@ <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> @@ -1550,7 +1552,7 @@ <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> @@ -1558,10 +1560,12 @@ <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> @@ -1571,7 +1575,9 @@ <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> -<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 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> diff --git a/source/text/scalc/01/func_networkdays.xhp b/source/text/scalc/01/func_networkdays.xhp index 5eeac272c8..f22da61b03 100644 --- a/source/text/scalc/01/func_networkdays.xhp +++ b/source/text/scalc/01/func_networkdays.xhp @@ -29,6 +29,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3151254"> <bookmark_value>NETWORKDAYS function</bookmark_value> + <bookmark_value>NETWORKDAYS_EXCEL2003 function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_NETWORKDAYS" id="bm_id3153696" localize="false"/> |