diff options
Diffstat (limited to 'source/text/scalc/01/04060106.xhp')
| -rw-r--r-- | source/text/scalc/01/04060106.xhp | 99 |
1 files changed, 0 insertions, 99 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index a34aba2f39..0bd8172ee0 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -688,105 +688,6 @@ <paragraph id="par_id3157916" role="paragraph" xml-lang="en-US"><item type="input">=LOG10(5)</item> returns the base-10 logarithm of 5 (approximately 0.69897).</paragraph><comment>see also LOG, LN, POWER</comment> </section> -<section id="Section31"> -<bookmark xml-lang="en-US" branch="index" id="bm_id3152518"> - <bookmark_value>CEILING function</bookmark_value> - <bookmark_value>rounding;up to multiples of significance</bookmark_value> -</bookmark> -<comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_OBERGRENZE" id="bm_id3152530" localize="false"/> - -<h2 id="hd_id3152518">CEILING</h2> -<paragraph id="par_id3153422" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_OBERGRENZE">Rounds a number up to the nearest multiple of Significance.</ahelp></paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3153454" role="code" xml-lang="en-US">CEILING(Number; Significance; Mode)</paragraph> -<paragraph id="par_id3153467" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded up.</paragraph> -<paragraph id="par_id3155000" role="paragraph" xml-lang="en-US"><emph>Significance</emph> is the number to whose multiple the value is to be rounded up.</paragraph> -<paragraph id="par_id3155020" 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 away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero.</paragraph> -<warning id="par_id3163792">If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that exists since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions. Note that CEILING.XCL always rounds away from zero.</warning> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3145710" role="paragraph" xml-lang="en-US"><item type="input">=CEILING(-11;-2)</item> returns -10</paragraph> -<paragraph id="par_id3145725" role="paragraph" xml-lang="en-US"><item type="input">=CEILING(-11;-2;0)</item> returns -10</paragraph> -<paragraph id="par_id3145740" role="paragraph" xml-lang="en-US"><item type="input">=CEILING(-11;-2;1)</item> returns -12</paragraph><comment>see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> -</section> - -<section id="Section31.1"> -<bookmark xml-lang="en-US" branch="index" id="bm_id2952518"> - <bookmark_value>CEILING.PRECISE function</bookmark_value> - <bookmark_value>rounding;up to multiples of significance</bookmark_value> -</bookmark> -<comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_MS" id="bm_id2952530" localize="false"/> - -<h2 id="hd_id2952518">CEILING.PRECISE</h2> -<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 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_id2953454" role="code" xml-lang="en-US">CEILING.PRECISE(Number; Significance)</paragraph> -<paragraph id="par_id2953467" role="paragraph" xml-lang="en-US"><emph>Number</emph> (required) is the number that is to be rounded up.</paragraph> -<paragraph id="par_id2955000" role="paragraph" xml-lang="en-US"><emph>Significance</emph> (optional) is the number to whose multiple the value is to be rounded up.</paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id2945710" role="paragraph" xml-lang="en-US"><item type="input">=CEILING.PRECISE(-11;-2)</item> returns -10</paragraph><comment>see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> -</section> - -<section id="Section 31.3"> - <bookmark xml-lang="en-US" branch="index" id="bm_id911516997198644"> - <bookmark_value>CEILING.MATH function</bookmark_value> - </bookmark> - <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_MATH" id="bm_id511516997249645" localize="false"/> - <h2 id="hd_id91516997330445">CEILING.MATH</h2> - <paragraph role="paragraph" id="par_id81516997342088" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MATH">Rounds a number up to the nearest multiple of Significance.</ahelp></paragraph> - <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> - <paragraph role="paragraph" id="par_id651516997706287" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded up.</paragraph> - <paragraph role="paragraph" id="par_id491516997725772" xml-lang="en-US"><emph>Significance</emph> is the number to whose multiple the value is to be rounded up.</paragraph> - <paragraph role="paragraph" id="par_id451516997742909" 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 away from zero. If the Mode value is equal to zero or is not given, negative numbers are rounded towards zero.</paragraph> - <warning id="par_id291516998575663">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_id111516997803684" xml-lang="en-US"><item type="input">=CEILING.MATH(-10;-3)</item> returns -9</paragraph> - <paragraph role="paragraph" id="par_id1001516997821483" xml-lang="en-US"><item type="input">=CEILING.MATH(-10;-3;0)</item> returns -9</paragraph> - <paragraph role="paragraph" id="par_id641516997837754" xml-lang="en-US"><item type="item_type">=CEILING.MATH(-10;-3;1)</item> returns -12</paragraph> -</section> -<section id="Section 31.4"> - <bookmark xml-lang="en-US" branch="index" id="bm_id921516998608939"> - <bookmark_value>CEILING.XCL function</bookmark_value> - </bookmark> - <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_MS" id="bm_id221516998652517" localize="false"/> - <h2 id="hd_id411516998838823">CEILING.XCL</h2> - <paragraph role="paragraph" id="par_id811516998845826" xml-lang="en-US"><ahelp hid="HID_FUNC_CEIL_MS">Rounds a number away from zero to the nearest multiple of Significance.</ahelp></paragraph> - <embed href="text/scalc/00/avail_release.xhp#5.0"/> - <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> - <paragraph role="code" id="par_id251516998856873" xml-lang="en-US">CEILING.XCL(Number; Significance)</paragraph> - <paragraph role="paragraph" id="par_id671516998874263" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded.</paragraph> - <paragraph role="paragraph" id="par_id151516998882622" xml-lang="en-US"><emph>Significance</emph> is the number to whose multiple the value is to be rounded.</paragraph> - <warning id="par_id341516998889754">This function exists for interoperability with Microsoft Excel 2007 or older versions.</warning> - <embed href="text/scalc/01/common_func.xhp#sectionexample"/> - <paragraph role="paragraph" id="par_id91516998917254" xml-lang="en-US"><item type="input">=CEILING.XCL(1;3)</item> returns 3</paragraph> - <paragraph role="paragraph" id="par_id761516998929693" xml-lang="en-US"><item type="input">=CEILING.XCL(7;4)</item> returns 8</paragraph> - <paragraph role="paragraph" id="par_id671516998958873" xml-lang="en-US"><item type="item_type">=CEILING.XCL(-10;-3)</item> returns -12</paragraph> -</section> -<section id="Section31.2"> -<bookmark xml-lang="en-US" branch="index" id="bm_id8952518"> - <bookmark_value>ISO.CEILING function</bookmark_value> - <bookmark_value>rounding;up to multiples of significance</bookmark_value> -</bookmark> -<comment>mw added one entry</comment> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_ISO" id="bm_id8952530" localize="false"/> - -<h2 id="hd_id8952518">ISO.CEILING</h2> -<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 Significance, regardless of sign of Significance</ahelp></paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id8953454" role="code" xml-lang="en-US">ISO.CEILING(Number; Significance)</paragraph> -<paragraph id="par_id8953467" role="paragraph" xml-lang="en-US"><emph>Number</emph> (required) is the number that is to be rounded up.</paragraph> -<paragraph id="par_id8955000" role="paragraph" xml-lang="en-US"><emph>Significance</emph> (optional) is the number to whose multiple the value is to be rounded up.</paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id8945710" role="paragraph" xml-lang="en-US"><item type="input">=ISO.CEILING(-11;-2)</item> returns -10</paragraph><comment>see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> -</section> <section id="Section30"> <bookmark xml-lang="en-US" branch="index" id="bm_id3157762"> |