diff options
Diffstat (limited to 'source/text/scalc/01/func_ceiling.xhp')
| -rw-r--r-- | source/text/scalc/01/func_ceiling.xhp | 20 |
1 files changed, 16 insertions, 4 deletions
diff --git a/source/text/scalc/01/func_ceiling.xhp b/source/text/scalc/01/func_ceiling.xhp index 6eecc5b92a..deb8eca555 100644 --- a/source/text/scalc/01/func_ceiling.xhp +++ b/source/text/scalc/01/func_ceiling.xhp @@ -54,7 +54,6 @@ <paragraph id="par_id2953422" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MS">Rounds a number up to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id151586642494759">For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored.</paragraph> <note id="par_id631586642933797">This function calculates identical results to the <link href="#Section312" name="isoceiling">ISO.CEILING</link> function.</note> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2953454" role="code" xml-lang="en-US">CEILING.PRECISE(Number [; Significance])</paragraph> <embed href="text/scalc/01/func_ceiling.xhp#argnumber"/> @@ -62,6 +61,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id201586213398634"><input>=CEILING.PRECISE(3.45)</input> returns 4.</paragraph> <paragraph role="paragraph" id="par_id651586213406243"><input>=CEILING.PRECISE(-45.67; 2)</input> returns -44.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640373986703" localize="false"><literal>COM.MICROSOFT.CEILING.PRECISE</literal></paragraph> <comment>see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> </section> @@ -73,7 +76,6 @@ <h2 id="hd_id91516997330445"><variable id="CEILING.MATHh1"><link href="text/scalc/01/func_ceiling.xhp#ceilingmath" name="CEILING.MATH">CEILING.MATH</link></variable></h2> <paragraph role="paragraph" id="par_id81516997342088" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MATH">Rounds a number to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id911586642319078">For a positive number the function rounds up (away from 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_id291516998575663">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_id841516997669932" xml-lang="en-US">CEILING.MATH(Number [; Significance [; Mode]])</paragraph> @@ -86,6 +88,10 @@ <paragraph role="paragraph" id="par_id641586208600665"><input>=CEILING.MATH(-1.234)</input> returns -1.</paragraph> <paragraph role="paragraph" id="par_id151586208604536"><input>=CEILING.MATH(-45.67; -2; 0)</input> returns -44.</paragraph> <paragraph role="paragraph" id="par_id971586208611345"><input>=CEILING.MATH(-45.67; +2; 1)</input> returns -46.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#5.0"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341646873986703" localize="false"><literal>COM.MICROSOFT.CEILING.MATH</literal></paragraph> </section> <section id="ceilingxcl"> <bookmark xml-lang="en-US" branch="index" id="bm_id921516998608939"> @@ -95,7 +101,6 @@ <h2 id="hd_id411516998838823"><variable id="CEILING.XCLh1"><link href="text/scalc/01/func_ceiling.xhp#ceilingxcl" name="CEILING.XCL">CEILING.XCL</link></variable></h2> <paragraph role="paragraph" id="par_id811516998845826" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MS">Rounds a number to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id361586213828675">For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a positive significance value, the function rounds up (towards zero). For a negative number and a negative significance value, the function rounds down (away from 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_id881586213934118">This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s CEILING.XCL function are exported as references to Excel’s CEILING function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s CEILING function are imported as references to Calc’s CEILING.XCL function.</warning> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id251516998856873" xml-lang="en-US">CEILING.XCL(Number; Significance)</paragraph> @@ -105,6 +110,10 @@ <paragraph role="paragraph" id="par_id421586214128242"><input>=CEILING.XCL(3.45,2)</input> returns 4.</paragraph> <paragraph role="paragraph" id="par_id651586214132234"><input>=CEILING.XCL(-45.67; 2)</input> returns -44.</paragraph> <paragraph role="paragraph" id="par_id811586214136666"><input>=CEILING.XCL(-45.67; -2)</input> returns -46.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#5.0"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873786703" localize="false"><literal>COM.MICROSOFT.CEILING</literal></paragraph> </section> <section id="isoceiling"> <bookmark xml-lang="en-US" branch="index" id="bm_id8952518"> @@ -118,7 +127,6 @@ <paragraph id="par_id8953422" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_ISO">Rounds a number up to the nearest multiple of a significance value.</ahelp></paragraph> <paragraph role="paragraph" id="par_id101586214229587">For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored.</paragraph> <note id="par_id821586214265060">This function calculates identical results to the <link href="#Section311" name="ceilingprecise">CEILING.PRECISE</link> function.</note> - <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id8953454" role="code" xml-lang="en-US">ISO.CEILING(Number [; Significance])</paragraph> <embed href="text/scalc/01/func_ceiling.xhp#argnumber"/> @@ -126,6 +134,10 @@ <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id801586214431463"><input>=ISO.CEILING(3.45)</input> returns 4.</paragraph> <paragraph role="paragraph" id="par_id181586214438808"><input>=ISO.CEILING(-45.67; 2)</input> returns -44.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> + <embed href="text/scalc/00/avail_release.xhp#4.3"/> + <embed href="text/scalc/01/common_func.xhp#notODFF"/> + <paragraph role="paragraph" id="par_id341640873989703" localize="false"><literal>COM.MICROSOFT.ISO.CEILING</literal></paragraph> <comment>see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> </section> <section id="relatedtopics"> |