AllLangHelp_scalc.mk | 1
source/text/scalc/01/04060106.xhp | 99 -------------------------
source/text/scalc/01/func_ceiling.xhp | 132 ++++++++++++++++++++++++++++++++++
3 files changed, 133 insertions(+), 99 deletions(-)
New commits:
commit 2d238deabf589c10ab89b495d3f9e2c57a8efda0
Author: Steve Fanning <stevemfanning...@gmail.com>
AuthorDate: Tue Apr 7 15:34:09 2020 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Thu Apr 9 00:32:33 2020 +0200
tdf#131960 Clarification of CEILING function
+ refactor, grouping all CEILING variants into one file
Change-Id: Ie82a1c72c8eab69457391ccc82543497fe168fa2
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91855
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk
index 32fe1d62e..aeee43364 100644
--- a/AllLangHelp_scalc.mk
+++ b/AllLangHelp_scalc.mk
@@ -189,6 +189,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\
helpcontent2/source/text/scalc/01/func_aggregate \
helpcontent2/source/text/scalc/01/func_averageif \
helpcontent2/source/text/scalc/01/func_averageifs \
+ helpcontent2/source/text/scalc/01/func_ceiling \
helpcontent2/source/text/scalc/01/func_countifs \
helpcontent2/source/text/scalc/01/func_color \
helpcontent2/source/text/scalc/01/func_concat \
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index a34aba2f3..0bd8172ee 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">
diff --git a/source/text/scalc/01/func_ceiling.xhp
b/source/text/scalc/01/func_ceiling.xhp
new file mode 100644
index 000000000..65c28d868
--- /dev/null
+++ b/source/text/scalc/01/func_ceiling.xhp
@@ -0,0 +1,132 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+ <!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ -->
+
+ <meta>
+ <topic id="scalcceilingfunction" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">Ceiling functions</title>
+ <filename>/text/scalc/01/func_ceiling.xhp</filename>
+ </topic>
+ </meta>
+ <body>
+ <h1 id="hd_id971586216771519">Ceiling functions</h1>
+ <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>
+
+ <paragraph role="paragraph" id="par_id601586207136514">For a positive
number and a positive significance value, the function rounds up (away from
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"/>
+ <paragraph id="par_id3153454" role="code"
xml-lang="en-US">CEILING(Number[; Significance[; Mode]])</paragraph>
+ <section id="argnumber">
+ <paragraph id="par_id3153467" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded, or a
reference to a cell containing the number.</paragraph>
+ </section>
+ <paragraph id="par_id3155000" role="paragraph"
xml-lang="en-US"><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 or -1 depending on the sign of
<emph>Number</emph>.</paragraph>
+ <paragraph id="par_id3155020" role="paragraph"
xml-lang="en-US"><emph>Mode</emph> (optional) is a number, or a reference to a
cell containing a number. The function only uses <emph>Mode</emph> if both
<emph>Number</emph> and <emph>Significance</emph> are negative. Then if
<emph>Mode</emph> is given and not equal to zero, numbers are rounded down
(away from zero); if <emph>Mode</emph> is equal to zero or not given, negative
numbers are rounded up (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 role="paragraph"
id="par_id281586208138400"><input>=CEILING(3.45)</input> returns 4.</paragraph>
+ <paragraph role="paragraph"
id="par_id921586208142416"><input>=CEILING(3.45, 3)</input> returns
6.</paragraph>
+ <paragraph role="paragraph"
id="par_id921586208146984"><input>=CEILING(-1.234)</input> returns
-1.</paragraph>
+ <paragraph role="paragraph"
id="par_id491586208152183"><input>=CEILING(-45.67, -2, 0)</input> returns
-44.</paragraph>
+ <paragraph role="paragraph"
id="par_id291586208158119"><input>=CEILING(-45.67, -2, 1)</input> returns
-46.</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 a
significance value.</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>
+ <embed href="text/scalc/01/func_ceiling.xhp#argnumber"/>
+ <paragraph id="par_id2955000" role="paragraph"
xml-lang="en-US"><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>
+ <note id="par_id461586211894475">This function calculates identical
results to the ISO.CEILING function</note>
+ <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>
+ <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 to the nearest
multiple of a significance value.</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>
+ <embed href="text/scalc/01/func_ceiling.xhp#argnumber"/>
+ <paragraph role="paragraph" id="par_id491516997725772"
xml-lang="en-US"><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_id451516997742909"
xml-lang="en-US"><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 down (away from zero). If
<emph>Mode</emph> is equal to zero or is not given, a negative
<emph>Number</emph> is rounded up (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_id331586208590009"><input>=CEILING.MATH(3.45)</input> returns
4.</paragraph>
+ <paragraph role="paragraph"
id="par_id481586208595809"><input>=CEILING.MATH(3.45,-3)</input> returns
6.</paragraph>
+ <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>
+ </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 to the nearest
multiple of a significance value.</ahelp></paragraph>
+ <embed href="text/scalc/00/avail_release.xhp#5.0"/>
+ <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>
+ <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>
+ <embed href="text/scalc/01/func_ceiling.xhp#argnumber"/>
+ <paragraph role="paragraph" id="par_id151516998882622"
xml-lang="en-US"><emph>Significance</emph> is the value, or a reference to a
cell containing the value, to whose multiple <emph>Number</emph> is to be
rounded.</paragraph>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+ <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>
+ </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 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 CEILING.PRECISE function</note>
+ <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"/>
+ <paragraph id="par_id8955000" role="paragraph"
xml-lang="en-US"><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>
+ <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>
+ <comment>see also FLOOR, EVEN, ODD, MROUND, INT, TRUNC, ROUND,
ROUNDDOWN, ROUNDUP</comment>
+ </section>
+</body>
+</helpdocument>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
