diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060106.xhp')
| -rw-r--r-- | helpcontent2/source/text/scalc/01/04060106.xhp | 88 |
1 files changed, 41 insertions, 47 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060106.xhp b/helpcontent2/source/text/scalc/01/04060106.xhp index 43ebf2f839..52357b0a82 100644 --- a/helpcontent2/source/text/scalc/01/04060106.xhp +++ b/helpcontent2/source/text/scalc/01/04060106.xhp @@ -900,26 +900,23 @@ INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> <bookmark xml-lang="en-US" branch="index" id="bm_id3158121"><bookmark_value>ROUND function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_FUNC_RUNDEN" id="bm_id3158133" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3158121" role="heading" level="2" l10n="U" - oldref="398">ROUND</paragraph> - <paragraph xml-lang="en-US" id="par_id3158150" role="paragraph" l10n="CHG" oldref="399"><ahelp hid="HID_FUNC_RUNDEN">Rounds a number to a certain number of decimal places.</ahelp></paragraph> - <paragraph xml-lang="en-US" id="hd_id3158169" role="heading" level="3" l10n="U" - oldref="400">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3158182" role="code" l10n="U" oldref="401">ROUND(Number; Count)</paragraph> - <paragraph xml-lang="en-US" id="par_id3158196" role="paragraph" l10n="U" oldref="402">Returns <emph>Number</emph> rounded to <emph>Count</emph> decimal places. If Count is omitted or zero, the function rounds to the nearest integer. If Ccunt is negative, the function rounds to the nearest 10, 100, 1000, etc.</paragraph> - <paragraph xml-lang="en-US" id="par_id599688" role="paragraph" l10n="NEW">This function rounds to the nearest number. See ROUNDDOWN and ROUNDUP for alternatives.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3145863" role="heading" level="3" l10n="U" - oldref="404">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3145876" role="paragraph" l10n="CHG" oldref="405"> - <item type="input">=ROUND(2.348;2)</item> returns 2.35</paragraph> - <paragraph xml-lang="en-US" id="par_id3145899" role="paragraph" l10n="CHG" oldref="406"> - <item type="input">=ROUND(-32.4834;3)</item> returns -32.483. Change the cell format to see all decimals.</paragraph> - <paragraph xml-lang="en-US" id="par_id1371501" role="paragraph" l10n="NEW"> - <item type="input">=ROUND(2.348;0)</item> returns 2.</paragraph> - <paragraph xml-lang="en-US" id="par_id4661702" role="paragraph" l10n="NEW"> - <item type="input">=ROUND(2.5)</item> returns 3. </paragraph> - <paragraph xml-lang="en-US" id="par_id7868892" role="paragraph" l10n="NEW"> - <item type="input">=ROUND(987.65;-2)</item> returns 1000.</paragraph><comment>see also INT, TRUNC, ROUNDDOWN, ROUNDUP, +<paragraph role="heading" id="hd_id3158121" xml-lang="en-US" level="2" l10n="U" oldref="398">ROUND</paragraph> +<paragraph role="paragraph" id="par_id3158150" xml-lang="en-US" l10n="CHG" oldref="399"><ahelp hid="HID_FUNC_RUNDEN">Rounds a number to a certain number of decimal places.</ahelp></paragraph> +<paragraph role="heading" id="hd_id3158169" xml-lang="en-US" level="3" l10n="U" oldref="400">Syntax</paragraph> +<paragraph role="code" id="par_id3158182" xml-lang="en-US" l10n="U" oldref="401">ROUND(Number; Count)</paragraph> +<paragraph role="paragraph" id="par_id3158196" xml-lang="en-US" l10n="U" oldref="402">Returns <emph>Number</emph> rounded to <emph>Count</emph> decimal places. If Count is omitted or zero, the function rounds to the nearest integer. If Count is negative, the function rounds to the nearest 10, 100, 1000, etc.</paragraph> +<paragraph role="paragraph" id="par_id599688" xml-lang="en-US" l10n="NEW">This function rounds to the nearest number. See ROUNDDOWN and ROUNDUP for alternatives.</paragraph> +<paragraph role="heading" id="hd_id3145863" xml-lang="en-US" level="3" l10n="U" oldref="404">Example</paragraph> +<paragraph role="paragraph" id="par_id3145876" xml-lang="en-US" l10n="CHG" oldref="405"> +<item type="input">=ROUND(2.348;2)</item> returns 2.35</paragraph> +<paragraph role="paragraph" id="par_id3145899" xml-lang="en-US" l10n="CHG" oldref="406"> +<item type="input">=ROUND(-32.4834;3)</item> returns -32.483. Change the cell format to see all decimals.</paragraph> +<paragraph role="paragraph" id="par_id1371501" xml-lang="en-US" l10n="NEW"> +<item type="input">=ROUND(2.348;0)</item> returns 2.</paragraph> +<paragraph role="paragraph" id="par_id4661702" xml-lang="en-US" l10n="NEW"> +<item type="input">=ROUND(2.5)</item> returns 3. </paragraph> +<paragraph role="paragraph" id="par_id7868892" xml-lang="en-US" l10n="NEW"> +<item type="input">=ROUND(987.65;-2)</item> returns 1000.</paragraph><comment>see also INT, TRUNC, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND</comment> </section> <section id="Section20"> @@ -1431,33 +1428,30 @@ INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> <bookmark_value>counting;specified cells</bookmark_value> </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/HID_FUNC_ZAEHLENWENN" id="bm_id3164909" localize="false"/> -<paragraph xml-lang="en-US" id="hd_id3164897" role="heading" level="2" l10n="U" - oldref="547">COUNTIF</paragraph> - <paragraph xml-lang="en-US" id="par_id3164926" role="paragraph" l10n="CHG" oldref="548"><ahelp hid="HID_FUNC_ZAEHLENWENN">Returns the number of cells that meet with certain criteria within a cell range.</ahelp></paragraph> - <embed href="text/shared/00/00000001.xhp#regulaer"/> - <paragraph xml-lang="en-US" id="hd_id3164953" role="heading" level="3" l10n="U" - oldref="549">Syntax</paragraph> - <paragraph xml-lang="en-US" id="par_id3164967" role="code" l10n="U" oldref="550">COUNTIF(Range; Criteria)</paragraph> - <paragraph xml-lang="en-US" id="par_id3164980" role="paragraph" l10n="U" oldref="551"> - <emph>Range</emph> is the range to which the criteria are to be applied.</paragraph> - <paragraph xml-lang="en-US" id="par_id3165000" role="paragraph" l10n="CHG" oldref="552"> - <emph>Criteria</emph> indicates the criteria in the form of a number, an expression or a character string. These criteria determine which cells are counted. You may also enter a search text in the form of a regular expression, e.g. b.* for all words that begin with b. You may also indicate a cell range that contains the search criterion. If you search for literal text, enclose the text in double quotes.</paragraph> - <paragraph xml-lang="en-US" id="hd_id3165037" role="heading" level="3" l10n="U" - oldref="553">Example</paragraph> - <paragraph xml-lang="en-US" id="par_id3166505" role="paragraph" l10n="CHG" oldref="627">A1:A10 is a cell range containing the numbers <item type="input">2000</item> to <item type="input">2009</item>. Cell B1 contains the number <item type="input">2006</item>. In cell B2, you enter a formula:</paragraph> - <paragraph xml-lang="en-US" id="par_id3581652" role="paragraph" l10n="NEW"> - <item type="input">=COUNTIF(A1:A10;2006)</item> - this returns 1</paragraph> - <paragraph xml-lang="en-US" id="par_id708639" role="paragraph" l10n="NEW"> - <item type="input">=COUNTIF(A1:A10;B1)</item> - this returns 1</paragraph> - <paragraph xml-lang="en-US" id="par_id5169225" role="paragraph" l10n="NEW"> - <item type="input">=COUNTIF(A1:A10;">=2006") </item>- this returns 3</paragraph> - <paragraph xml-lang="en-US" id="par_id2118594" role="paragraph" l10n="NEW"> - <item type="input">=COUNTIF(A1:A10;"<"&B1)</item> - when B1 contains <item type="input">2006</item>, this returns 6</paragraph> - <paragraph xml-lang="en-US" id="par_id166020" role="paragraph" l10n="NEW"> - <item type="input">=COUNTIF(A1:A10;C2)</item> where cell C2 contains the text <item type="input">>2006</item> counts the number of cells in the range A1:A10 which are >2006 </paragraph> - <paragraph xml-lang="en-US" id="par_id6386913" role="paragraph" l10n="NEW">To count only negative numbers: <item type="input">=COUNTIF(A1:A10;"<0")</item> - </paragraph> - </section> +<paragraph role="heading" id="hd_id3164897" xml-lang="en-US" level="2" l10n="U" oldref="547">COUNTIF</paragraph> +<paragraph role="paragraph" id="par_id3164926" xml-lang="en-US" l10n="CHG" oldref="548"><ahelp hid="HID_FUNC_ZAEHLENWENN">Returns the number of cells that meet with certain criteria within a cell range.</ahelp></paragraph> +<embed href="text/shared/00/00000001.xhp#regulaer"/> +<paragraph role="heading" id="hd_id3164953" xml-lang="en-US" level="3" l10n="U" oldref="549">Syntax</paragraph> +<paragraph role="code" id="par_id3164967" xml-lang="en-US" l10n="U" oldref="550">COUNTIF(Range; Criteria)</paragraph> +<paragraph role="paragraph" id="par_id3164980" xml-lang="en-US" l10n="U" oldref="551"> +<emph>Range</emph> is the range to which the criteria are to be applied.</paragraph> +<paragraph role="paragraph" id="par_id3165000" xml-lang="en-US" l10n="CHG" oldref="552"> +<emph>Criteria</emph> indicates the criteria in the form of a number, an expression or a character string. These criteria determine which cells are counted. You may also enter a search text in the form of a regular expression, e.g. b.* for all words that begin with b. You may also indicate a cell range that contains the search criterion. If you search for literal text, enclose the text in double quotes.</paragraph> +<paragraph role="heading" id="hd_id3165037" xml-lang="en-US" level="3" l10n="U" oldref="553">Example</paragraph> +<paragraph role="paragraph" id="par_id3166505" xml-lang="en-US" l10n="CHG" oldref="627">A1:A10 is a cell range containing the numbers <item type="input">2000</item> to <item type="input">2009</item>. Cell B1 contains the number <item type="input">2006</item>. In cell B2, you enter a formula:</paragraph> +<paragraph role="paragraph" id="par_id3581652" xml-lang="en-US" l10n="NEW"> +<item type="input">=COUNTIF(A1:A10;2006)</item> - this returns 1</paragraph> +<paragraph role="paragraph" id="par_id708639" xml-lang="en-US" l10n="NEW"> +<item type="input">=COUNTIF(A1:A10;B1)</item> - this returns 1</paragraph> +<paragraph role="paragraph" id="par_id5169225" xml-lang="en-US" l10n="NEW"> +<item type="input">=COUNTIF(A1:A10;">=2006") </item>- this returns 4</paragraph> +<paragraph role="paragraph" id="par_id2118594" xml-lang="en-US" l10n="NEW"> +<item type="input">=COUNTIF(A1:A10;"<"&B1)</item> - when B1 contains <item type="input">2006</item>, this returns 6</paragraph> +<paragraph role="paragraph" id="par_id166020" xml-lang="en-US" l10n="NEW"> +<item type="input">=COUNTIF(A1:A10;C2)</item> where cell C2 contains the text <item type="input">>2006</item> counts the number of cells in the range A1:A10 which are >2006 </paragraph> +<paragraph role="paragraph" id="par_id6386913" xml-lang="en-US" l10n="NEW">To count only negative numbers: <item type="input">=COUNTIF(A1:A10;"<0")</item> +</paragraph> +</section> </sort> <section id="relatedtopics"> <embed href="text/scalc/01/04060100.xhp#drking"/> |