diff options
| author | Rüdiger Timm <rt@openoffice.org> | 2006-12-01 15:50:11 +0000 |
|---|---|---|
| committer | Rüdiger Timm <rt@openoffice.org> | 2006-12-01 15:50:11 +0000 |
| commit | 5c44f782f0d9ef7ddd3877bf6087410961c16b2f (patch) | |
| tree | 14001f1518365e8277f6de43b8d5f3de083c1056 | |
| parent | 29e3e0716a538cadcb3a73e5ce39279a9bb73ddb (diff) | |
INTEGRATION: CWS hcshared06 (1.7.38); FILE MERGED
2006/11/08 08:28:54 ufi 1.7.38.3: building
2006/11/07 12:17:08 ufi 1.7.38.2: calc enhancements
2006/11/03 07:47:18 ufi 1.7.38.1: saving
| -rw-r--r-- | helpcontent2/source/text/scalc/01/04060106.xhp | 147 |
1 files changed, 86 insertions, 61 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060106.xhp b/helpcontent2/source/text/scalc/01/04060106.xhp index dca03d31d4..1c5ab40d4a 100644 --- a/helpcontent2/source/text/scalc/01/04060106.xhp +++ b/helpcontent2/source/text/scalc/01/04060106.xhp @@ -6,9 +6,9 @@ * * $RCSfile: 04060106.xhp,v $ * - * $Revision: 1.7 $ + * $Revision: 1.8 $ * - * last change: $Author: ihi $ $Date: 2006-06-29 09:39:12 $ + * last change: $Author: rt $ $Date: 2006-12-01 16:50:11 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -44,7 +44,7 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2006-05-09T11:18:34">UFI: fixed #i25926#, added missing head2 lines, +<lastedited date="2006-11-07T14:09:50">UFI: fixed #i25926#, added missing head2 lines, also fixed #i24074#, also fixed #i18230# discovered all internal links were empty, so deleted them with FPEs approval.; dedr: reviewed</lastedited> </history> @@ -52,7 +52,7 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3147124"><bookmark_value>mathematical functions</bookmark_value> <bookmark_value>Function Wizard; mathematical</bookmark_value> -<bookmark_value>functions; mathematical</bookmark_value> +<bookmark_value>functions; mathematical functions</bookmark_value> <bookmark_value>trigonometric functions</bookmark_value> </bookmark><comment>mw added "trigonometric..."</comment> <paragraph role="heading" id="hd_id3147124" xml-lang="en-US" level="1" l10n="U" oldref="1">Mathematical Functions</paragraph> @@ -344,12 +344,14 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d <bookmark xml-lang="en-US" branch="hid/HID_FUNC_GGT" id="bm_id3149737" localize="false"/> <paragraph role="heading" id="hd_id3147356" xml-lang="en-US" level="2" l10n="U" oldref="237">GCD</paragraph> <paragraph role="paragraph" id="par_id3152465" xml-lang="en-US" l10n="U" oldref="238"><ahelp hid="HID_FUNC_GGT">Returns the greatest common divisor of two or more integers.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id2769249" xml-lang="en-US" l10n="NEW">The greatest common divisor is the positive largest integer which will divide, without remainder, each of the given integers.</paragraph> <paragraph role="heading" id="hd_id3150643" xml-lang="en-US" level="3" l10n="U" oldref="239">Syntax:</paragraph> <paragraph role="code" id="par_id3154524" xml-lang="en-US" l10n="U" oldref="240">GCD(integer 1 to 30)</paragraph> <paragraph role="paragraph" id="par_id3149340" xml-lang="en-US" l10n="U" oldref="241"> <emph>Integer 1 to 30</emph> are up to 30 integers whose greatest common divisor is to be calculated.</paragraph> <paragraph role="heading" id="hd_id3147317" xml-lang="en-US" level="3" l10n="U" oldref="242">Example:</paragraph> -<paragraph role="paragraph" id="par_id3151285" xml-lang="en-US" l10n="U" oldref="243">If you enter the numbers 512;1024 and 2000 in text boxes Integer 1;2 and 3, 16 will be returned as the result.</paragraph> +<paragraph role="paragraph" id="par_id3151285" xml-lang="en-US" l10n="CHG" oldref="243">GCD(16;32;24) gives the result 8, because 8 is the largest number that can divide 16, 24 and 32 without a remainder.</paragraph> +<paragraph role="paragraph" id="par_id1604663" xml-lang="en-US" l10n="NEW">GCD(B1:B3) where cells B1, B2, B3 contain 9, 12, 9 gives 3.</paragraph> </section> <section id="Section42"> <bookmark xml-lang="en-US" branch="index" id="bm_id3151221"><bookmark_value>GCD_ADD function</bookmark_value> @@ -548,11 +550,11 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_FUNC_PI" id="bm_id3157774" localize="false"/> <paragraph role="heading" id="hd_id3157762" xml-lang="en-US" level="2" l10n="U" oldref="343">PI</paragraph> -<paragraph role="paragraph" id="par_id3157790" xml-lang="en-US" l10n="U" oldref="344"><ahelp hid="HID_FUNC_PI">Returns the value of PI (rounded value 3.14159).</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3157790" xml-lang="en-US" l10n="CHG" oldref="344"><ahelp hid="HID_FUNC_PI">Returns 3.14159265358979, the value of the mathematical constant PI to 14 decimal places.</ahelp></paragraph> <paragraph role="heading" id="hd_id3157809" xml-lang="en-US" level="3" l10n="U" oldref="345">Syntax:</paragraph> <paragraph role="code" id="par_id3157822" xml-lang="en-US" l10n="U" oldref="346">PI()</paragraph> <paragraph role="heading" id="hd_id3157836" xml-lang="en-US" level="3" l10n="U" oldref="347">Example:</paragraph> -<paragraph role="paragraph" id="par_id3152370" xml-lang="en-US" l10n="U" oldref="348">Pi is 3.14159... as a rounded value.</paragraph> +<paragraph role="paragraph" id="par_id3152370" xml-lang="en-US" l10n="CHG" oldref="348">=PI() returns 3.14159265358979.</paragraph> </section> <section id="Section29"> <bookmark xml-lang="en-US" branch="index" id="bm_id3152418"><bookmark_value>MULTINOMIAL function</bookmark_value> @@ -653,12 +655,13 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/HID_AAI_FUNC_QUOTIENT" id="bm_id3144603" localize="false"/> <paragraph role="heading" id="hd_id3144592" xml-lang="en-US" level="2" l10n="E" oldref="652">QUOTIENT</paragraph> +<paragraph role="paragraph" id="par_id3144627" xml-lang="en-US" l10n="CHG" oldref="653"><ahelp hid="HID_AAI_FUNC_QUOTIENT">Returns the integer part of a division.</ahelp></paragraph> <embed href="text/shared/00/00000001.xhp#add"/> -<paragraph role="paragraph" id="par_id3144627" xml-lang="en-US" l10n="U" oldref="653"><ahelp hid="HID_AAI_FUNC_QUOTIENT">Returns the integer result of a division operation.</ahelp></paragraph> <paragraph role="heading" id="hd_id3144646" xml-lang="en-US" level="3" l10n="U" oldref="654">Syntax</paragraph> <paragraph role="code" id="par_id3144659" xml-lang="en-US" l10n="U" oldref="655">QUOTIENT(Numerator;Denominator)</paragraph> +<paragraph role="paragraph" id="par_id7059236" xml-lang="en-US" l10n="NEW">Returns the integer part of Numerator divided by Denominator. QUOTIENT is equivalent to INT(Numerator/Denominator), except that it may report errors with different error codes.</paragraph> <paragraph role="heading" id="hd_id3144674" xml-lang="en-US" level="3" l10n="U" oldref="656">Example</paragraph> -<paragraph role="paragraph" id="par_id3144687" xml-lang="en-US" l10n="U" oldref="657">=QUOTIENT(11;3) returns 3. The remainder of 2 is omitted.</paragraph> +<paragraph role="paragraph" id="par_id3144687" xml-lang="en-US" l10n="CHG" oldref="657">=QUOTIENT(11;3) returns 3. The remainder of 2 is lost.</paragraph> </section> <section id="Section22"> <bookmark xml-lang="en-US" branch="index" id="bm_id3144702"><bookmark_value>RADIANS function</bookmark_value> @@ -767,7 +770,7 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d <paragraph role="paragraph" id="par_id3151828" xml-lang="en-US" l10n="U" oldref="623">In order to enter this as an array formula, you must press the Shift <switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>+ Ctrl</defaultinline></switchinline> + Enter key instead of simply pressing the Enter key to close the formula. The formula will then be shown in the <emph>Formula</emph> bar enclosed in braces.</paragraph> <paragraph role="paragraph" id="par_id3151869" xml-lang="en-US" l10n="U" oldref="624">{=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)}</paragraph> -<paragraph role="paragraph" id="par_id3151884" xml-lang="en-US" l10n="U" oldref="625">The formula is based on the fact that the result of a comparison is 1, if the criterion is met and 0 if it is not. The individual comparison results will be treated as an array and used in matrix multiplication, and at the end the individual values will be totaled to give the result matrix. The SUM() function can also be used in this way, for example, as COUNTIF() with several criteria.</paragraph> +<paragraph role="paragraph" id="par_id3151884" xml-lang="en-US" l10n="CHG" oldref="625">The formula is based on the fact that the result of a comparison is 1, if the criterion is met and 0 if it is not. The individual comparison results will be treated as an array and used in matrix multiplication, and at the end the individual values will be totaled to give the result matrix.</paragraph> </section> <section id="Section15"> <bookmark xml-lang="en-US" branch="index" id="bm_id3151957"><bookmark_value>SUMIF function</bookmark_value> @@ -787,6 +790,8 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d <emph>Sum_range</emph> is the range from which values are summed. If this parameter has not been indicated, the values found in the <emph>Range</emph> are summed.</paragraph> <paragraph role="heading" id="hd_id3152110" xml-lang="en-US" level="3" l10n="U" oldref="443">Example:</paragraph> <paragraph role="paragraph" id="par_id3152148" xml-lang="en-US" l10n="CHG" oldref="626">To sum up only negative numbers: SUMIF(A1:A10;"<0")</paragraph> +<paragraph role="paragraph" id="par_id6670125" xml-lang="en-US" l10n="NEW">=SUMIF(A1:A10;">0";B1:10) - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0.</paragraph> +<paragraph role="paragraph" id="par_id6062196" xml-lang="en-US" l10n="NEW">See COUNTIF() for some more syntax examples that can be used with SUMIF().</paragraph> </section> <section id="Section14"> <bookmark xml-lang="en-US" branch="index" id="bm_id3152195"><bookmark_value>TAN function</bookmark_value> @@ -941,7 +946,7 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_FUNC_UMRECHNEN" id="bm_id3143684" localize="false"/> <paragraph role="heading" id="hd_id3143672" xml-lang="en-US" level="2" l10n="U" oldref="564">CONVERT</paragraph> -<paragraph role="paragraph" id="par_id3143708" xml-lang="en-US" l10n="CHG" oldref="565"><ahelp hid="HID_FUNC_UMRECHNEN">This function allows you to convert a European currency value into Euros.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3143708" xml-lang="en-US" l10n="CHG" oldref="565"><ahelp hid="HID_FUNC_UMRECHNEN">This function converts the former European currency values that are replaced by Euros now into Euros.</ahelp></paragraph> <paragraph role="paragraph" id="par_id3143731" xml-lang="en-US" l10n="U" oldref="566"> <emph>Syntax:</emph> </paragraph> @@ -959,170 +964,184 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d <table id="tbl_id3143894"> <tablerow> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3143922" xml-lang="en-US" l10n="U" oldref="574">"EUR"</paragraph> +<paragraph role="tablecontent" id="par_id3143922" xml-lang="en-US" l10n="U" oldref="574">"EUR"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3143945" xml-lang="en-US" l10n="U" oldref="575">"ATS"</paragraph> +<paragraph role="tablecontent" id="par_id3143945" xml-lang="en-US" l10n="U" oldref="575">"ATS"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3143968" xml-lang="en-US" l10n="U" oldref="576">13.7603</paragraph> +<paragraph role="tablecontent" id="par_id3143968" xml-lang="en-US" l10n="U" oldref="576">13.7603</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3143991" xml-lang="en-US" l10n="U" oldref="577">Austrian Schilling</paragraph> +<paragraph role="tablecontent" id="par_id3143991" xml-lang="en-US" l10n="U" oldref="577">Austrian Schilling</paragraph> </tablecell> </tablerow> <tablerow> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3144018" xml-lang="en-US" l10n="U" oldref="578">"EUR"</paragraph> +<paragraph role="tablecontent" id="par_id3144018" xml-lang="en-US" l10n="U" oldref="578">"EUR"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3144041" xml-lang="en-US" l10n="U" oldref="579">"BEF"</paragraph> +<paragraph role="tablecontent" id="par_id3144041" xml-lang="en-US" l10n="U" oldref="579">"BEF"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3144064" xml-lang="en-US" l10n="U" oldref="580">40.3399</paragraph> +<paragraph role="tablecontent" id="par_id3144064" xml-lang="en-US" l10n="U" oldref="580">40.3399</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3144087" xml-lang="en-US" l10n="U" oldref="581">Belgian Franc</paragraph> +<paragraph role="tablecontent" id="par_id3144087" xml-lang="en-US" l10n="U" oldref="581">Belgian Franc</paragraph> </tablecell> </tablerow> <tablerow> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3144114" xml-lang="en-US" l10n="U" oldref="582">"EUR"</paragraph> +<paragraph role="tablecontent" id="par_id3144114" xml-lang="en-US" l10n="U" oldref="582">"EUR"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3144137" xml-lang="en-US" l10n="U" oldref="583">"DEM"</paragraph> +<paragraph role="tablecontent" id="par_id3144137" xml-lang="en-US" l10n="U" oldref="583">"DEM"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3144160" xml-lang="en-US" l10n="U" oldref="584">1.95583</paragraph> +<paragraph role="tablecontent" id="par_id3144160" xml-lang="en-US" l10n="U" oldref="584">1.95583</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3144183" xml-lang="en-US" l10n="U" oldref="585">German Mark</paragraph> +<paragraph role="tablecontent" id="par_id3144183" xml-lang="en-US" l10n="U" oldref="585">German Mark</paragraph> </tablecell> </tablerow> <tablerow> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3144210" xml-lang="en-US" l10n="U" oldref="586">"EUR"</paragraph> +<paragraph role="tablecontent" id="par_id3144210" xml-lang="en-US" l10n="U" oldref="586">"EUR"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3144233" xml-lang="en-US" l10n="U" oldref="587">"ESP"</paragraph> +<paragraph role="tablecontent" id="par_id3144233" xml-lang="en-US" l10n="U" oldref="587">"ESP"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3144256" xml-lang="en-US" l10n="U" oldref="588">166.386</paragraph> +<paragraph role="tablecontent" id="par_id3144256" xml-lang="en-US" l10n="U" oldref="588">166.386</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3144279" xml-lang="en-US" l10n="U" oldref="589">Spanish Peseta</paragraph> +<paragraph role="tablecontent" id="par_id3144279" xml-lang="en-US" l10n="U" oldref="589">Spanish Peseta</paragraph> </tablecell> </tablerow> <tablerow> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3144306" xml-lang="en-US" l10n="U" oldref="590">"EUR"</paragraph> +<paragraph role="tablecontent" id="par_id3144306" xml-lang="en-US" l10n="U" oldref="590">"EUR"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3144329" xml-lang="en-US" l10n="U" oldref="591">"FIM"</paragraph> +<paragraph role="tablecontent" id="par_id3144329" xml-lang="en-US" l10n="U" oldref="591">"FIM"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156466" xml-lang="en-US" l10n="U" oldref="592">5.94573</paragraph> +<paragraph role="tablecontent" id="par_id3156466" xml-lang="en-US" l10n="U" oldref="592">5.94573</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156488" xml-lang="en-US" l10n="U" oldref="593">Finnish Markka</paragraph> +<paragraph role="tablecontent" id="par_id3156488" xml-lang="en-US" l10n="U" oldref="593">Finnish Markka</paragraph> </tablecell> </tablerow> <tablerow> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156516" xml-lang="en-US" l10n="U" oldref="594">"EUR"</paragraph> +<paragraph role="tablecontent" id="par_id3156516" xml-lang="en-US" l10n="U" oldref="594">"EUR"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156539" xml-lang="en-US" l10n="U" oldref="595">"FRF"</paragraph> +<paragraph role="tablecontent" id="par_id3156539" xml-lang="en-US" l10n="U" oldref="595">"FRF"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156562" xml-lang="en-US" l10n="U" oldref="596">6.55957</paragraph> +<paragraph role="tablecontent" id="par_id3156562" xml-lang="en-US" l10n="U" oldref="596">6.55957</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156584" xml-lang="en-US" l10n="U" oldref="597">French Franc</paragraph> +<paragraph role="tablecontent" id="par_id3156584" xml-lang="en-US" l10n="U" oldref="597">French Franc</paragraph> </tablecell> </tablerow> <tablerow> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156612" xml-lang="en-US" l10n="U" oldref="598">"EUR"</paragraph> +<paragraph role="tablecontent" id="par_id3156612" xml-lang="en-US" l10n="U" oldref="598">"EUR"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156635" xml-lang="en-US" l10n="U" oldref="599">"IEP"</paragraph> +<paragraph role="tablecontent" id="par_id3156635" xml-lang="en-US" l10n="U" oldref="599">"IEP"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156658" xml-lang="en-US" l10n="U" oldref="600">0.787564</paragraph> +<paragraph role="tablecontent" id="par_id3156658" xml-lang="en-US" l10n="U" oldref="600">0.787564</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156680" xml-lang="en-US" l10n="U" oldref="601">Irish Pound</paragraph> +<paragraph role="tablecontent" id="par_id3156680" xml-lang="en-US" l10n="U" oldref="601">Irish Pound</paragraph> </tablecell> </tablerow> <tablerow> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156708" xml-lang="en-US" l10n="U" oldref="602">"EUR"</paragraph> +<paragraph role="tablecontent" id="par_id3156708" xml-lang="en-US" l10n="U" oldref="602">"EUR"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156730" xml-lang="en-US" l10n="U" oldref="603">"ITL"</paragraph> +<paragraph role="tablecontent" id="par_id3156730" xml-lang="en-US" l10n="U" oldref="603">"ITL"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156753" xml-lang="en-US" l10n="U" oldref="604">1936.27</paragraph> +<paragraph role="tablecontent" id="par_id3156753" xml-lang="en-US" l10n="U" oldref="604">1936.27</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156776" xml-lang="en-US" l10n="U" oldref="605">Italian Lira</paragraph> +<paragraph role="tablecontent" id="par_id3156776" xml-lang="en-US" l10n="U" oldref="605">Italian Lira</paragraph> </tablecell> </tablerow> <tablerow> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156804" xml-lang="en-US" l10n="U" oldref="606">"EUR"</paragraph> +<paragraph role="tablecontent" id="par_id3156804" xml-lang="en-US" l10n="U" oldref="606">"EUR"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156826" xml-lang="en-US" l10n="U" oldref="607">"LUF"</paragraph> +<paragraph role="tablecontent" id="par_id3156826" xml-lang="en-US" l10n="U" oldref="607">"LUF"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156849" xml-lang="en-US" l10n="U" oldref="608">40.3399</paragraph> +<paragraph role="tablecontent" id="par_id3156849" xml-lang="en-US" l10n="U" oldref="608">40.3399</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156872" xml-lang="en-US" l10n="U" oldref="609">Luxembourg Franc</paragraph> +<paragraph role="tablecontent" id="par_id3156872" xml-lang="en-US" l10n="U" oldref="609">Luxembourg Franc</paragraph> </tablecell> </tablerow> <tablerow> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156900" xml-lang="en-US" l10n="U" oldref="610">"EUR"</paragraph> +<paragraph role="tablecontent" id="par_id3156900" xml-lang="en-US" l10n="U" oldref="610">"EUR"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156922" xml-lang="en-US" l10n="U" oldref="611">"NLG"</paragraph> +<paragraph role="tablecontent" id="par_id3156922" xml-lang="en-US" l10n="U" oldref="611">"NLG"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156945" xml-lang="en-US" l10n="U" oldref="612">2.20371</paragraph> +<paragraph role="tablecontent" id="par_id3156945" xml-lang="en-US" l10n="U" oldref="612">2.20371</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156968" xml-lang="en-US" l10n="U" oldref="613">Dutch Guilder</paragraph> +<paragraph role="tablecontent" id="par_id3156968" xml-lang="en-US" l10n="U" oldref="613">Dutch Guilder</paragraph> </tablecell> </tablerow> <tablerow> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3156996" xml-lang="en-US" l10n="U" oldref="614">"EUR"</paragraph> +<paragraph role="tablecontent" id="par_id3156996" xml-lang="en-US" l10n="U" oldref="614">"EUR"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3157018" xml-lang="en-US" l10n="U" oldref="615">"PTE"</paragraph> +<paragraph role="tablecontent" id="par_id3157018" xml-lang="en-US" l10n="U" oldref="615">"PTE"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3157041" xml-lang="en-US" l10n="U" oldref="616">200.482</paragraph> +<paragraph role="tablecontent" id="par_id3157041" xml-lang="en-US" l10n="U" oldref="616">200.482</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3157064" xml-lang="en-US" l10n="U" oldref="617">Portuguese Escudo</paragraph> +<paragraph role="tablecontent" id="par_id3157064" xml-lang="en-US" l10n="U" oldref="617">Portuguese Escudo</paragraph> </tablecell> </tablerow> <tablerow> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3157092" xml-lang="en-US" l10n="U" oldref="631">"EUR"</paragraph> +<paragraph role="tablecontent" id="par_id3157092" xml-lang="en-US" l10n="U" oldref="631">"EUR"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3157114" xml-lang="en-US" l10n="U" oldref="632">"GRD"</paragraph> +<paragraph role="tablecontent" id="par_id3157114" xml-lang="en-US" l10n="U" oldref="632">"GRD"</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3157137" xml-lang="en-US" l10n="U" oldref="633">340.750</paragraph> +<paragraph role="tablecontent" id="par_id3157137" xml-lang="en-US" l10n="U" oldref="633">340.750</paragraph> </tablecell> <tablecell colspan="" rowspan=""> -<paragraph role="paragraph" id="par_id3157160" xml-lang="en-US" l10n="U" oldref="634">Greek Drachma</paragraph> +<paragraph role="tablecontent" id="par_id3157160" xml-lang="en-US" l10n="U" oldref="634">Greek Drachma</paragraph> +</tablecell> +</tablerow> +<tablerow> +<tablecell colspan="" rowspan=""> +<paragraph role="tablecontent" id="par_id733970" xml-lang="en-US" l10n="NEW">"EUR"</paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="tablecontent" id="par_id341196" xml-lang="en-US" l10n="NEW">"SIT"</paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="tablecontent" id="par_id4224372" xml-lang="en-US" l10n="NEW">239.640</paragraph> +</tablecell> +<tablecell colspan="" rowspan=""> +<paragraph role="tablecontent" id="par_id295724" xml-lang="en-US" l10n="NEW">Slovenian Tolar</paragraph> </tablecell> </tablerow> </table> @@ -1254,7 +1273,7 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d </bookmark><comment>mw added one entry</comment> <bookmark xml-lang="en-US" branch="hid/HID_FUNC_ZAEHLENWENN" id="bm_id3164909" localize="false"/> <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="U" oldref="548"><ahelp hid="HID_FUNC_ZAEHLENWENN">Returns the number of elements that meet with certain criteria within a cell range.</ahelp></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> @@ -1263,7 +1282,13 @@ discovered all internal links were empty, so deleted them with FPEs approval.; d <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="U" oldref="627">An example can be found under SUM().</paragraph> +<paragraph role="paragraph" id="par_id3166505" xml-lang="en-US" l10n="CHG" oldref="627">A1:A10 is a cell range containing the numbers 2000 to 2009. Cell B1 contains the number 2006. In cell B2, you enter a formula:</paragraph> +<paragraph role="paragraph" id="par_id3581652" xml-lang="en-US" l10n="NEW">=COUNTIF(A1:A10;2006) - this returns 1</paragraph> +<paragraph role="paragraph" id="par_id708639" xml-lang="en-US" l10n="NEW">=COUNTIF(A1:A10;B1) - this returns 1</paragraph> +<paragraph role="paragraph" id="par_id5169225" xml-lang="en-US" l10n="NEW">=COUNTIF(A1:A10;">=2006") - this returns 3</paragraph> +<paragraph role="paragraph" id="par_id2118594" xml-lang="en-US" l10n="NEW">=COUNTIF(A1:A10;"<"&B1) - when B1 contains 2006, this returns 6</paragraph> +<paragraph role="paragraph" id="par_id166020" xml-lang="en-US" l10n="NEW">=COUNTIF(A1:A10;C2) where cell C2 contains the text ">2006" (without the double quotes) - 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: COUNTIF(A1:A10;"<0")</paragraph> </section> </sort> </body> |