diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-09-29 15:26:04 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2018-10-02 08:54:16 +0200 |
| commit | b358fb9b95915743d8666b238acb8e117c8751ce (patch) | |
| tree | 7913b29b55f56ffa83d7a7e57f96340db7536410 /source/text/scalc/01/04060106.xhp | |
| parent | tdf#103527 Remove Colors from Options help (diff) | |
| download | help-b358fb9b95915743d8666b238acb8e117c8751ce.tar.gz help-b358fb9b95915743d8666b238acb8e117c8751ce.zip | |
Reduce L10N workload for repetitive strings
Change 'Syntax' and 'Examples' heading into an embedded string
translated only once.
Change-Id: Iac2eef8fedbaa4461aa2f941af7f065a3b16fb2d
Reviewed-on: https://gerrit.libreoffice.org/61143
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01/04060106.xhp')
| -rw-r--r-- | source/text/scalc/01/04060106.xhp | 266 |
1 files changed, 133 insertions, 133 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 297f91c12c..5523e4b198 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -51,11 +51,11 @@ <paragraph id="hd_id3146944" role="heading" level="2" xml-lang="en-US">ABS</paragraph> <paragraph id="par_id3154546" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ABS">Returns the absolute value of a number.</ahelp></paragraph> -<paragraph id="hd_id3154843" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3147475" role="code" xml-lang="en-US">ABS(Number)</paragraph> <paragraph id="par_id3148438" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the number whose absolute value is to be calculated. The absolute value of a number is its value without the +/- sign.</paragraph> -<paragraph id="hd_id3155823" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3152787" role="paragraph" xml-lang="en-US"><item type="input">=ABS(-56)</item> returns 56.</paragraph> <paragraph id="par_id3148752" role="paragraph" xml-lang="en-US"><item type="input">=ABS(12)</item> returns 12.</paragraph> <paragraph id="par_id320139" role="paragraph" xml-lang="en-US"><item type="input">=ABS(0)</item> returns 0.<comment>see also SIGN</comment></paragraph> @@ -71,12 +71,12 @@ <paragraph id="hd_id3153114" role="heading" level="2" xml-lang="en-US">ACOS</paragraph> <paragraph id="par_id3145163" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCCOS">Returns the inverse trigonometric cosine of a number.</ahelp></paragraph> -<paragraph id="hd_id3153565" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3150020" role="code" xml-lang="en-US">ACOS(Number)</paragraph> <paragraph id="par_id3159134" role="paragraph" xml-lang="en-US">This function returns the inverse trigonometric cosine of <emph>Number</emph>, that is the angle (in radians) whose cosine is Number. The angle returned is between 0 and PI.</paragraph> <paragraph id="par_id679647" role="paragraph" xml-lang="en-US">To return the angle in degrees, use the DEGREES function.</paragraph> -<paragraph id="hd_id3149882" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3150128" role="paragraph" xml-lang="en-US"><item type="input">=ACOS(-1)</item> returns 3.14159265358979 (PI radians)</paragraph> <paragraph id="par_id8792382" role="paragraph" xml-lang="en-US"><item type="input">=DEGREES(ACOS(0.5))</item> returns 60. The cosine of 60 degrees is 0.5.</paragraph><comment>see also COS, SIN, TAN, COT, ASIN, ATAN, ATAN2, ACOT</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> @@ -92,12 +92,12 @@ <paragraph id="hd_id3145355" role="heading" level="2" xml-lang="en-US">ACOSH</paragraph> <paragraph id="par_id3157993" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCOSHYP">Returns the inverse hyperbolic cosine of a number.</ahelp></paragraph> -<paragraph id="hd_id3145295" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3151017" role="code" xml-lang="en-US">ACOSH(Number)</paragraph> <paragraph id="par_id3149000" role="paragraph" xml-lang="en-US">This function returns the inverse hyperbolic cosine of <emph>Number</emph>, that is the number whose hyperbolic cosine is Number.</paragraph> <paragraph id="par_id6393932" role="paragraph" xml-lang="en-US">Number must be greater than or equal to 1.</paragraph> -<paragraph id="hd_id3150566" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3145629" role="paragraph" xml-lang="en-US"><item type="input">=ACOSH(1)</item> returns 0.</paragraph> <paragraph id="par_id951567" role="paragraph" xml-lang="en-US"><item type="input">=ACOSH(COSH(4))</item> returns 4.</paragraph><comment>see also ASINH, ATANH, ACOTH, COSH, SINH, TANH, COTH</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> @@ -113,12 +113,12 @@ <paragraph id="hd_id3149027" role="heading" level="2" xml-lang="en-US">ACOT</paragraph> <paragraph id="par_id3155818" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCCOT">Returns the inverse cotangent (the arccotangent) of the given number.</ahelp></paragraph> -<paragraph id="hd_id3153225" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3158419" role="code" xml-lang="en-US">ACOT(Number)</paragraph> <paragraph id="par_id3154948" role="paragraph" xml-lang="en-US">This function returns the inverse trigonometric cotangent of <emph>Number</emph>, that is the angle (in radians) whose cotangent is Number. The angle returned is between 0 and PI.</paragraph> <paragraph id="par_id5834528" role="paragraph" xml-lang="en-US">To return the angle in degrees, use the DEGREES function.</paragraph> -<paragraph id="hd_id3147538" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3155375" role="paragraph" xml-lang="en-US"><item type="input">=ACOT(1)</item> returns 0.785398163397448 (PI/4 radians).</paragraph> <paragraph id="par_id8589434" role="paragraph" xml-lang="en-US"><item type="input">=DEGREES(ACOT(1))</item> returns 45. The tangent of 45 degrees is 1.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ASIN, ATAN, ATAN2</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> @@ -134,12 +134,12 @@ <paragraph id="hd_id3148426" role="heading" level="2" xml-lang="en-US">ACOTH</paragraph> <paragraph id="par_id3147478" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCOTHYP">Returns the inverse hyperbolic cotangent of the given number.</ahelp></paragraph> -<paragraph id="hd_id3152585" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3147172" role="code" xml-lang="en-US">ACOTH(Number)</paragraph> <paragraph id="par_id3146155" role="paragraph" xml-lang="en-US">This function returns the inverse hyperbolic cotangent of <emph>Number</emph>, that is the number whose hyperbolic cotangent is Number.</paragraph> <paragraph id="par_id5818659" role="paragraph" xml-lang="en-US">An error results if Number is between -1 and 1 inclusive.</paragraph> -<paragraph id="hd_id3083452" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3150608" role="paragraph" xml-lang="en-US"><item type="input">=ACOTH(1.1)</item> returns inverse hyperbolic cotangent of 1.1, approximately 1.52226.</paragraph><comment>see also ACOSH, ASINH, ATANH, COSH, SINH, TANH, COTH</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> </section> @@ -160,12 +160,12 @@ <paragraph id="hd_id3145084" role="heading" level="2" xml-lang="en-US">ASIN</paragraph> <paragraph id="par_id3156296" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCSIN">Returns the inverse trigonometric sine of a number.</ahelp></paragraph> -<paragraph id="hd_id3149716" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3156305" role="code" xml-lang="en-US">ASIN(Number)</paragraph> <paragraph id="par_id3150964" role="paragraph" xml-lang="en-US">This function returns the inverse trigonometric sine of <emph>Number</emph>, that is the angle (in radians) whose sine is Number. The angle returned is between -PI/2 and +PI/2.</paragraph> <paragraph id="par_id203863" role="paragraph" xml-lang="en-US">To return the angle in degrees, use the DEGREES function.</paragraph> -<paragraph id="hd_id3149448" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3156100" role="paragraph" xml-lang="en-US"><item type="input">=ASIN(0)</item> returns 0.</paragraph> <paragraph id="par_id6853846" role="paragraph" xml-lang="en-US"><item type="input">=ASIN(1)</item> returns 1.5707963267949 (PI/2 radians).</paragraph> <paragraph id="par_id8772240" role="paragraph" xml-lang="en-US"><item type="input">=DEGREES(ASIN(0.5))</item> returns 30. The sine of 30 degrees is 0.5.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ATAN, ATAN2, ACOT</comment> @@ -182,11 +182,11 @@ <paragraph id="hd_id3151266" role="heading" level="2" xml-lang="en-US">ASINH</paragraph> <paragraph id="par_id3147077" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARSINHYP">Returns the inverse hyperbolic sine of a number.</ahelp></paragraph> -<paragraph id="hd_id3150763" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3150882" role="code" xml-lang="en-US">ASINH(Number)</paragraph> <paragraph id="par_id3147621" role="paragraph" xml-lang="en-US">This function returns the inverse hyperbolic sine of <emph>Number</emph>, that is the number whose hyperbolic sine is Number.</paragraph> -<paragraph id="hd_id3153212" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3156120" role="paragraph" xml-lang="en-US"><item type="input">=ASINH(-90)</item> returns approximately -5.1929877.</paragraph> <paragraph id="par_id4808496" role="paragraph" xml-lang="en-US"><item type="input">=ASINH(SINH(4))</item> returns 4.</paragraph><comment>see also ACOSH, ATANH, ACOTH, COSH, SINH, TANH, COTH</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> @@ -202,12 +202,12 @@ <paragraph id="hd_id3155996" role="heading" level="2" xml-lang="en-US">ATAN</paragraph> <paragraph id="par_id3149985" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCTAN">Returns the inverse trigonometric tangent of a number.</ahelp></paragraph> -<paragraph id="hd_id3151294" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3150261" role="code" xml-lang="en-US">ATAN(Number)</paragraph> <paragraph id="par_id3147267" role="paragraph" xml-lang="en-US">This function returns the inverse trigonometric tangent of <emph>Number</emph>, that is the angle (in radians) whose tangent is Number. The angle returned is between -PI/2 and PI/2.</paragraph> <paragraph id="par_id6293527" role="paragraph" xml-lang="en-US">To return the angle in degrees, use the DEGREES function.</paragraph> -<paragraph id="hd_id3154054" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3143229" role="paragraph" xml-lang="en-US"><item type="input">=ATAN(1)</item> returns 0.785398163397448 (PI/4 radians).</paragraph> <paragraph id="par_id8746299" role="paragraph" xml-lang="en-US"><item type="input">=DEGREES(ATAN(1))</item> returns 45. The tangent of 45 degrees is 1.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ASIN, ATAN2, ACOT</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> @@ -223,14 +223,14 @@ <paragraph id="hd_id3153983" role="heading" level="2" xml-lang="en-US">ATAN2</paragraph> <paragraph id="par_id3154297" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARCTAN2">Returns the inverse trigonometric tangent of the specified x and y coordinates.</ahelp></paragraph> -<paragraph id="hd_id3149758" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3156013" role="code" xml-lang="en-US">ATAN2(NumberX; NumberY)</paragraph> <paragraph id="par_id3151168" role="paragraph" xml-lang="en-US"><emph>NumberX</emph> is the value of the x coordinate.</paragraph> <paragraph id="par_id3152798" role="paragraph" xml-lang="en-US"><emph>NumberY</emph> is the value of the y coordinate.</paragraph> <paragraph id="par_id5036164" role="paragraph" xml-lang="en-US">ATAN2 returns the inverse trigonometric tangent, that is, the angle (in radians) between the x-axis and a line from point NumberX, NumberY to the origin. The angle returned is between -PI and PI.</paragraph> <paragraph id="par_id3001800" role="paragraph" xml-lang="en-US">To return the angle in degrees, use the DEGREES function.</paragraph> -<paragraph id="hd_id3145663" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3154692" role="paragraph" xml-lang="en-US"><item type="input">=ATAN2(20;20)</item> returns 0.785398163397448 (PI/4 radians).</paragraph> <paragraph id="par_id1477095" role="paragraph" xml-lang="en-US"><item type="input">=DEGREES(ATAN2(12.3;12.3))</item> returns 45. The tangent of 45 degrees is 1.</paragraph><comment>see also COS, SIN, TAN, COT, ACOS, ASIN, ATAN, ACOT</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> @@ -246,12 +246,12 @@ <paragraph id="hd_id3155398" role="heading" level="2" xml-lang="en-US">ATANH</paragraph> <paragraph id="par_id3148829" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ARTANHYP">Returns the inverse hyperbolic tangent of a number.</ahelp></paragraph> -<paragraph id="hd_id3146997" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3149912" role="code" xml-lang="en-US">ATANH(Number)</paragraph> <paragraph id="par_id3150521" role="paragraph" xml-lang="en-US">This function returns the inverse hyperbolic tangent of <emph>Number</emph>, that is the number whose hyperbolic tangent is Number.</paragraph> <paragraph id="par_id9357280" role="paragraph" xml-lang="en-US">Number must obey the condition -1 < number < 1.</paragraph> -<paragraph id="hd_id3148450" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3145419" role="paragraph" xml-lang="en-US"><item type="input">=ATANH(0)</item> returns 0.</paragraph><comment>see also ACOSH, ASINH, ACOTH, COSH, SINH, TANH, COTH</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> </section> @@ -266,12 +266,12 @@ <paragraph id="hd_id3153062" role="heading" level="2" xml-lang="en-US">COS</paragraph> <paragraph id="par_id3148803" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COS">Returns the cosine of the given angle (in radians).</ahelp></paragraph> -<paragraph id="hd_id3150779" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3154213" role="code" xml-lang="en-US">COS(Number)</paragraph> <paragraph id="par_id3154285" role="paragraph" xml-lang="en-US">Returns the (trigonometric) cosine of <emph>Number</emph>, the angle in radians.</paragraph> <paragraph id="par_id831019" role="paragraph" xml-lang="en-US">To return the cosine of an angle in degrees, use the RADIANS function.</paragraph> -<paragraph id="hd_id3153579" role="heading" level="3" xml-lang="en-US">Examples</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3147241" role="paragraph" xml-lang="en-US"><item type="input">=COS(PI()*2)</item> returns 1, the cosine of 2*PI radians.</paragraph> <paragraph id="par_id3147516" role="paragraph" xml-lang="en-US"><item type="input">=COS(RADIANS(60))</item> returns 0.5, the cosine of 60 degrees.</paragraph><comment>see also SIN, TAN, COT, ACOS, ASIN, ATAN, ATAN2, ACOT</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> @@ -287,11 +287,11 @@ <paragraph id="hd_id3154277" role="heading" level="2" xml-lang="en-US">COSH</paragraph> <paragraph id="par_id3146946" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COSHYP">Returns the hyperbolic cosine of a number.</ahelp></paragraph> -<paragraph id="hd_id3149792" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3166440" role="code" xml-lang="en-US">COSH(Number)</paragraph> <paragraph id="par_id3150710" role="paragraph" xml-lang="en-US">Returns the hyperbolic cosine of <emph>Number</emph>.</paragraph> -<paragraph id="hd_id3153234" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3154099" role="paragraph" xml-lang="en-US"><item type="input">=COSH(0)</item> returns 1, the hyperbolic cosine of 0.</paragraph><comment>see also SINH, TANH, COTH, ACOSH, ASINH, ATANH, ACOTH</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> </section> @@ -306,7 +306,7 @@ <paragraph id="hd_id3152888" role="heading" level="2" xml-lang="en-US">COT</paragraph> <paragraph id="par_id3153679" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COT">Returns the cotangent of the given angle (in radians).</ahelp></paragraph> -<paragraph id="hd_id3152943" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3154856" role="code" xml-lang="en-US">COT(Number)</paragraph> <paragraph id="par_id3149969" role="paragraph" xml-lang="en-US">Returns the (trigonometric) cotangent of <emph>Number</emph>, the angle in radians.</paragraph> <paragraph id="par_id3444624" role="paragraph" xml-lang="en-US">To return the cotangent of an angle in degrees, use the RADIANS function.</paragraph> @@ -328,11 +328,11 @@ <paragraph id="hd_id3154337" role="heading" level="2" xml-lang="en-US">COTH</paragraph> <paragraph id="par_id3149419" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COTHYP">Returns the hyperbolic cotangent of a given number (angle).</ahelp></paragraph> -<paragraph id="hd_id3149242" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3143280" role="code" xml-lang="en-US">COTH(Number)</paragraph> <paragraph id="par_id3154799" role="paragraph" xml-lang="en-US">Returns the hyperbolic cotangent of <emph>Number</emph>.</paragraph> -<paragraph id="hd_id3155422" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3144754" role="paragraph" xml-lang="en-US"><item type="input">=COTH(1)</item> returns the hyperbolic cotangent of 1, approximately 1.3130.</paragraph><comment>see also COSH, SINH, TANH, ACOSH, ASINH, ATANH, ACOTH</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> </section> @@ -347,12 +347,12 @@ <paragraph id="hd_id9523234" role="heading" level="2" xml-lang="en-US">CSC</paragraph> <paragraph id="par_id4896433" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COSECANT">Returns the cosecant of the given angle (in radians). The cosecant of an angle is equivalent to 1 divided by the sine of that angle</ahelp></paragraph> -<paragraph id="hd_id3534032" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id4571344" role="code" xml-lang="en-US">CSC(Number)</paragraph> <paragraph id="par_id9859164" role="paragraph" xml-lang="en-US">Returns the (trigonometric) cosecant of <emph>Number</emph>, the angle in radians.</paragraph> <paragraph id="par_id3428494" role="paragraph" xml-lang="en-US">To return the cosecant of an angle in degrees, use the RADIANS function.</paragraph> -<paragraph id="hd_id2577161" role="heading" level="3" xml-lang="en-US">Examples</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3736803" role="paragraph" xml-lang="en-US"><item type="input">=CSC(PI()/4)</item> returns approximately 1.4142135624, the inverse of the sine of PI/4 radians.</paragraph> <paragraph id="par_id6016818" role="paragraph" xml-lang="en-US"><item type="input">=CSC(RADIANS(30))</item> returns 2, the cosecant of 30 degrees.</paragraph><comment>see also SIN, TAN, COT, SEC, ACOS, ASIN, ATAN, ATAN2, ACOT</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> @@ -368,11 +368,11 @@ <paragraph id="hd_id4325650" role="heading" level="2" xml-lang="en-US">CSCH</paragraph> <paragraph id="par_id579916" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_COSECANTHYP">Returns the hyperbolic cosecant of a number.</ahelp></paragraph> -<paragraph id="hd_id5336768" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3108851" role="code" xml-lang="en-US">CSCH(Number)</paragraph> <paragraph id="par_id1394188" role="paragraph" xml-lang="en-US">Returns the hyperbolic cosecant of <emph>Number</emph>.</paragraph> -<paragraph id="hd_id6037477" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id5426085" role="paragraph" xml-lang="en-US"><item type="input">=CSCH(1)</item> returns approximately 0.8509181282, the hyperbolic cosecant of 1.</paragraph><comment>see also SINH, TANH, COTH, SECH,ACOSH, ASINH, ATANH, ACOTH</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> </section> @@ -388,11 +388,11 @@ <paragraph id="hd_id3145314" role="heading" level="2" xml-lang="en-US">DEGREES</paragraph> <paragraph id="par_id3149939" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_DEG">Converts radians into degrees.</ahelp></paragraph> -<paragraph id="hd_id3150623" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3145600" role="code" xml-lang="en-US">DEGREES(Number)</paragraph> <paragraph id="par_id3149484" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the angle in radians to be converted to degrees.</paragraph> -<paragraph id="hd_id3669545" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3459578" role="paragraph" xml-lang="en-US"><item type="input">=DEGREES(PI())</item> returns 180 degrees.</paragraph><comment>see also RADIANS</comment> </section> @@ -406,11 +406,11 @@ <paragraph id="hd_id3148698" role="heading" level="2" xml-lang="en-US">EXP</paragraph> <paragraph id="par_id3150592" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_EXP">Returns e raised to the power of a number.</ahelp> The constant e has a value of approximately 2.71828182845904.</paragraph> -<paragraph id="hd_id3150351" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3146786" role="code" xml-lang="en-US">EXP(Number)</paragraph> <paragraph id="par_id3155608" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the power to which e is to be raised.</paragraph> -<paragraph id="hd_id3154418" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3156340" role="paragraph" xml-lang="en-US"><item type="input">=EXP(1)</item> returns 2.71828182845904, the mathematical constant e to Calc's accuracy.</paragraph><comment>see also POWER, LN</comment> </section> @@ -425,13 +425,13 @@ <paragraph id="hd_id3145781" role="heading" level="2" xml-lang="en-US">FACT</paragraph> <paragraph id="par_id3151109" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FAKULTAET">Returns the factorial of a number.</ahelp></paragraph> -<paragraph id="hd_id3146902" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3154661" role="code" xml-lang="en-US">FACT(Number)</paragraph> <paragraph id="par_id3152952" role="paragraph" xml-lang="en-US">Returns Number!, the factorial of <emph>Number</emph>, calculated as 1*2*3*4* ... * Number.</paragraph> <paragraph id="par_id3834650" role="paragraph" xml-lang="en-US">=FACT(0) returns 1 by definition.</paragraph> <paragraph id="par_id8429517" role="paragraph" xml-lang="en-US">The factorial of a negative number returns the "invalid argument" error.</paragraph> -<paragraph id="hd_id3154569" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3154476" role="paragraph" xml-lang="en-US"><item type="input">=FACT(3)</item> returns 6.</paragraph> <paragraph id="par_id3147525" role="paragraph" xml-lang="en-US"><item type="input">=FACT(0)</item> returns 1.</paragraph><comment>see also FACTDOUBLE, MULTINOMIAL, PRODUCT</comment> </section> @@ -448,12 +448,12 @@ <paragraph id="hd_id3159084" role="heading" level="2" xml-lang="en-US">INT</paragraph> <paragraph id="par_id3158441" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_GANZZAHL">Rounds a number down to the nearest integer.</ahelp></paragraph> -<paragraph id="hd_id3146132" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3156146" role="code" xml-lang="en-US">INT(Number)</paragraph> <paragraph id="par_id3154117" role="paragraph" xml-lang="en-US">Returns <emph>Number</emph> rounded down to the nearest integer.</paragraph> <paragraph id="par_id153508" role="paragraph" xml-lang="en-US">Negative numbers round down to the integer below.</paragraph> -<paragraph id="hd_id3155118" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3156267" role="paragraph" xml-lang="en-US"><item type="input">=INT(5.7)</item> returns 5.</paragraph> <paragraph id="par_id3147323" role="paragraph" xml-lang="en-US"><item type="input">=INT(-1.3)</item> returns -2.</paragraph><comment>see also TRUNC, ROUND, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND</comment> </section> @@ -470,11 +470,11 @@ <paragraph id="hd_id3150938" role="heading" level="2" xml-lang="en-US">EVEN</paragraph> <paragraph id="par_id3149988" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_GERADE">Rounds a positive number up to the next even integer and a negative number down to the next even integer.</ahelp></paragraph> -<paragraph id="hd_id3148401" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3150830" role="code" xml-lang="en-US">EVEN(Number)</paragraph> <paragraph id="par_id3153350" role="paragraph" xml-lang="en-US">Returns <emph>Number</emph> rounded to the next even integer up, away from zero.</paragraph> -<paragraph id="hd_id3155508" role="heading" level="3" xml-lang="en-US">Examples</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3154361" role="paragraph" xml-lang="en-US"><item type="input">=EVEN(2.3)</item> returns 4.</paragraph> <paragraph id="par_id8477736" role="paragraph" xml-lang="en-US"><item type="input">=EVEN(2)</item> returns 2.</paragraph> <paragraph id="par_id159611" role="paragraph" xml-lang="en-US"><item type="input">=EVEN(0)</item> returns 0.</paragraph> @@ -493,11 +493,11 @@ <paragraph id="par_id3152465" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_GGT">Returns the greatest common divisor of two or more integers.</ahelp></paragraph> <paragraph id="par_id2769249" role="paragraph" xml-lang="en-US">The greatest common divisor is the positive largest integer which will divide, without remainder, each of the given integers.</paragraph> -<paragraph id="hd_id3150643" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3154524" role="code" xml-lang="en-US">GCD(Integer1; Integer2; ...; Integer30)</paragraph> <paragraph id="par_id3149340" role="paragraph" xml-lang="en-US"><emph>Integer1 To 30</emph> are up to 30 integers whose greatest common divisor is to be calculated.</paragraph> -<paragraph id="hd_id3147317" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3151285" role="paragraph" xml-lang="en-US"><item type="input">=GCD(16;32;24) </item>gives the result 8, because 8 is the largest number that can divide 16, 24 and 32 without a remainder.</paragraph> <paragraph id="par_id1604663" role="paragraph" xml-lang="en-US"><item type="input">=GCD(B1:B3)</item> where cells B1, B2, B3 contain <item type="input">9</item>, <item type="input">12</item>, <item type="input">9</item> gives 3.</paragraph> </section> @@ -513,11 +513,11 @@ <paragraph id="par_id3153257" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_GCD">The result is the greatest common divisor of a list of numbers.</ahelp></paragraph> <embed href="text/scalc/01/04060102.xhp#ADD_note"/> -<paragraph id="hd_id3147548" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3156205" role="code" xml-lang="en-US">GCD_EXCEL2003(Number(s))</paragraph> <paragraph id="par_id3145150" role="paragraph" xml-lang="en-US"><emph>Number(s)</emph> is a list of up to 30 numbers.</paragraph> -<paragraph id="hd_id3150239" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3159192" role="paragraph" xml-lang="en-US"><item type="input">=GCD_EXCEL2003(5;15;25)</item> returns 5.</paragraph> </section> @@ -533,11 +533,11 @@ <paragraph id="hd_id3145213" role="heading" level="2" xml-lang="en-US">LCM</paragraph> <paragraph id="par_id3146814" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_KGV">Returns the least common multiple of one or more integers.</ahelp></paragraph> -<paragraph id="hd_id3148632" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3147279" role="code" xml-lang="en-US">LCM(Integer1; Integer2; ...; Integer30)</paragraph> <paragraph id="par_id3156348" role="paragraph" xml-lang="en-US"><emph>Integer1 to 30</emph> are up to 30 integers whose lowest common multiple is to be calculated.</paragraph> -<paragraph id="hd_id3156431" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3154914" role="paragraph" xml-lang="en-US">If you enter the numbers <item type="input">512</item>;<item type="input">1024</item> and <item type="input">2000</item> in the Integer 1;2 and 3 text boxes, 128000 will be returned as the result.</paragraph> </section> @@ -552,11 +552,11 @@ <paragraph id="par_id3149036" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_LCM">The result is the lowest common multiple of a list of numbers.</ahelp></paragraph> <embed href="text/scalc/01/04060102.xhp#ADD_note"/> -<paragraph id="hd_id3153132" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3154395" role="code" xml-lang="en-US">LCM_EXCEL2003(Number(s))</paragraph> <paragraph id="par_id3147377" role="paragraph" xml-lang="en-US"><emph>Number(s)</emph> is a list of up to 30 numbers.</paragraph> -<paragraph id="hd_id3145122" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3145135" role="paragraph" xml-lang="en-US"><item type="input">=LCM_EXCEL2003(5;15;25)</item> returns 75.</paragraph> </section> @@ -571,14 +571,14 @@ <paragraph id="hd_id3155802" role="heading" level="2" xml-lang="en-US">COMBIN</paragraph> <paragraph id="par_id3156172" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_KOMBINATIONEN">Returns the number of combinations for elements without repetition.</ahelp></paragraph> -<paragraph id="hd_id3156193" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3150223" role="code" xml-lang="en-US">COMBIN(Count1; Count2)</paragraph> <paragraph id="par_id3150313" role="paragraph" xml-lang="en-US"><emph>Count1</emph> is the number of items in the set.</paragraph> <paragraph id="par_id3153830" role="paragraph" xml-lang="en-US"><emph>Count2</emph> is the number of items to choose from the set.</paragraph> <paragraph id="par_id6807458" role="paragraph" xml-lang="en-US">COMBIN returns the number of ordered ways to choose these items. For example if there are 3 items A, B and C in a set, you can choose 2 items in 3 different ways, namely AB, AC and BC.</paragraph> <paragraph id="par_id7414471" role="paragraph" xml-lang="en-US">COMBIN implements the formula: Count1!/(Count2!*(Count1-Count2)!)</paragraph> -<paragraph id="hd_id3153171" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3153517" role="paragraph" xml-lang="en-US"><item type="input">=COMBIN(3;2)</item> returns 3.</paragraph><comment>see also COMBINA</comment> </section> @@ -593,14 +593,14 @@ <paragraph id="hd_id3150284" role="heading" level="2" xml-lang="en-US">COMBINA</paragraph> <paragraph id="par_id3157894" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_KOMBINATIONEN2">Returns the number of combinations of a subset of items including repetitions.</ahelp></paragraph> -<paragraph id="hd_id3145752" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3145765" role="code" xml-lang="en-US">COMBINA(Count1; Count2)</paragraph> <paragraph id="par_id3153372" role="paragraph" xml-lang="en-US"><emph>Count1</emph> is the number of items in the set.</paragraph> <paragraph id="par_id3155544" role="paragraph" xml-lang="en-US"><emph>Count2</emph> is the number of items to choose from the set.</paragraph> <paragraph id="par_id1997131" role="paragraph" xml-lang="en-US">COMBINA returns the number of unique ways to choose these items, where the order of choosing is irrelevant, and repetition of items is allowed. For example if there are 3 items A, B and C in a set, you can choose 2 items in 6 different ways, namely AA, AB, AC, BB, BC and CC.</paragraph> <paragraph id="par_id2052064" role="paragraph" xml-lang="en-US">COMBINA implements the formula: (Count1+Count2-1)! / (Count2!(Count1-1)!)<comment>i88052</comment></paragraph> -<paragraph id="hd_id3154584" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3152904" role="paragraph" xml-lang="en-US"><item type="input">=COMBINA(3;2)</item> returns 6.</paragraph><comment>see also COMBIN</comment> </section> @@ -615,14 +615,14 @@ <paragraph id="hd_id3156086" role="heading" level="2" xml-lang="en-US">TRUNC</paragraph> <paragraph id="par_id3157866" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_KUERZEN">Truncates a number by removing decimal places.</ahelp></paragraph> -<paragraph id="hd_id3148499" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3148511" role="code" xml-lang="en-US">TRUNC(Number; Count)</paragraph> <paragraph id="par_id3150796" role="paragraph" xml-lang="en-US">Returns <emph>Number</emph> with at most <emph>Count</emph> decimal places. Excess decimal places are simply removed, irrespective of sign.</paragraph> <paragraph id="par_id3150816" role="paragraph" xml-lang="en-US"><item type="literal">TRUNC(Number; 0)</item> behaves as <item type="literal">INT(Number)</item> for positive numbers, but effectively rounds towards zero for negative numbers.</paragraph> <paragraph id="par_id3148548" role="warning" xml-lang="en-US">The <emph>visible</emph> decimal places of the result are specified in <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences </caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01060500.xhp">%PRODUCTNAME Calc - Calculate</link>.</paragraph> -<paragraph id="hd_id3152555" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3152569" role="paragraph" xml-lang="en-US"><item type="input">=TRUNC(1.239;2)</item> returns 1.23. The 9 is lost.</paragraph> <paragraph id="par_id7050080" role="paragraph" xml-lang="en-US"><item type="input">=TRUNC(-1.234999;3)</item> returns -1.234. All the 9s are lost.</paragraph><comment>see also INT, ROUND, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND</comment> </section> @@ -638,11 +638,11 @@ <paragraph id="hd_id3153601" role="heading" level="2" xml-lang="en-US">LN</paragraph> <paragraph id="par_id3154974" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LN">Returns the natural logarithm based on the constant e of a number.</ahelp> The constant e has a value of approximately 2.71828182845904.</paragraph> -<paragraph id="hd_id3154993" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3155284" role="code" xml-lang="en-US">LN(Number)</paragraph> <paragraph id="par_id3155297" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the value whose natural logarithm is to be calculated.</paragraph> -<paragraph id="hd_id3153852" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3153866" role="paragraph" xml-lang="en-US"><item type="input">=LN(3)</item> returns the natural logarithm of 3 (approximately 1.0986).</paragraph> <paragraph id="par_id5747245" role="paragraph" xml-lang="en-US"><item type="input">=LN(EXP(321))</item> returns 321.</paragraph><comment>see also LOG, LOG10, EXP</comment> </section> @@ -658,12 +658,12 @@ <paragraph id="hd_id3109813" role="heading" level="2" xml-lang="en-US">LOG</paragraph> <paragraph id="par_id3109841" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LOG">Returns the logarithm of a number to the specified base.</ahelp></paragraph> -<paragraph id="hd_id3144719" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3144732" role="code" xml-lang="en-US">LOG(Number; Base)</paragraph> <paragraph id="par_id3144746" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the value whose logarithm is to be calculated.</paragraph> <paragraph id="par_id3152840" role="paragraph" xml-lang="en-US"><emph>Base</emph> (optional) is the base for the logarithm calculation. If omitted, Base 10 is assumed.</paragraph> -<paragraph id="hd_id3152860" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3154429" role="paragraph" xml-lang="en-US"><item type="input">=LOG(10;3)</item> returns the logarithm to base 3 of 10 (approximately 2.0959).</paragraph> <paragraph id="par_id5577562" role="paragraph" xml-lang="en-US"><item type="input">=LOG(7^4;7)</item> returns 4.</paragraph><comment>see also LOG10, LN, POWER</comment> </section> @@ -679,11 +679,11 @@ <paragraph id="hd_id3154187" role="heading" level="2" xml-lang="en-US">LOG10</paragraph> <paragraph id="par_id3155476" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LOG10">Returns the base-10 logarithm of a number.</ahelp></paragraph> -<paragraph id="hd_id3155494" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3159294" role="code" xml-lang="en-US">LOG10(Number)</paragraph> <paragraph id="par_id3159308" role="paragraph" xml-lang="en-US">Returns the logarithm to base 10 of <emph>Number</emph>.</paragraph> -<paragraph id="hd_id3159328" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <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> @@ -698,14 +698,14 @@ <paragraph id="hd_id3152518" role="heading" level="2" xml-lang="en-US">CEILING</paragraph> <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 id="hd_id3153440" role="heading" level="3" xml-lang="en-US">Syntax</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> <paragraph id="par_id3163792" role="warning" xml-lang="en-US">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.</paragraph> -<paragraph id="hd_id3145697" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<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> @@ -722,12 +722,12 @@ <paragraph id="hd_id2952518" role="heading" level="2" xml-lang="en-US">CEILING.PRECISE</paragraph> <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> -<paragraph id="hd_id2953440" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<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> -<paragraph id="hd_id2945697" role="heading" level="3" xml-lang="en-US">Example</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> @@ -738,13 +738,13 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_MATH" id="bm_id511516997249645" localize="false"/> <paragraph role="heading" id="hd_id91516997330445" level="2" xml-lang="en-US">CEILING.MATH</paragraph> <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> - <paragraph role="heading" id="hd_id971516997377435" level="3" xml-lang="en-US">Syntax</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> <paragraph xml-lang="en-US" id="par_id291516998575663" role="warning">This function exists for interoperability with Microsoft Excel 2013 or newer.</paragraph> - <paragraph role="heading" id="hd_id561516997761868" level="3" xml-lang="en-US">Example</paragraph> + <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> @@ -756,12 +756,12 @@ <bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CEIL_MS" id="bm_id221516998652517" localize="false"/> <paragraph role="heading" id="hd_id411516998838823" level="2" xml-lang="en-US">CEILING.XCL</paragraph> <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> - <paragraph role="heading" id="hd_id361516998851918" level="3" xml-lang="en-US">Syntax</paragraph> + <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> <paragraph xml-lang="en-US" id="par_id341516998889754" role="warning">This function exists for interoperability with Microsoft Excel 2007 or older versions.</paragraph> - <paragraph role="heading" id="hd_id81516998896303" level="3" xml-lang="en-US">Example</paragraph> + <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> @@ -777,12 +777,12 @@ <paragraph id="hd_id8952518" role="heading" level="2" xml-lang="en-US">ISO.CEILING</paragraph> <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> -<paragraph id="hd_id8953440" role="heading" level="3" xml-lang="en-US">Syntax</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> -<paragraph id="hd_id8945697" role="heading" level="3" xml-lang="en-US">Example</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> @@ -796,10 +796,10 @@ <paragraph id="hd_id3157762" role="heading" level="2" xml-lang="en-US">PI</paragraph> <paragraph id="par_id3157790" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_PI">Returns 3.14159265358979, the value of the mathematical constant PI to 14 decimal places.</ahelp></paragraph> -<paragraph id="hd_id3157809" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3157822" role="code" xml-lang="en-US">PI()</paragraph> -<paragraph id="hd_id3157836" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3152370" role="paragraph" xml-lang="en-US"><item type="input">=PI()</item> returns 3.14159265358979.</paragraph> </section> @@ -813,11 +813,11 @@ <paragraph id="hd_id3152418" role="heading" level="2" xml-lang="en-US">MULTINOMIAL</paragraph> <paragraph id="par_id3152454" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_MULTINOMIAL">Returns the factorial of the sum of the arguments divided by the product of the factorials of the arguments.</ahelp></paragraph> -<paragraph id="hd_id3155646" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3155660" role="code" xml-lang="en-US">MULTINOMIAL(Number(s))</paragraph> <paragraph id="par_id3155673" role="paragraph" xml-lang="en-US"><emph>Number(s)</emph> is a list of up to 30 numbers.</paragraph> -<paragraph id="hd_id3155687" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3155701" role="paragraph" xml-lang="en-US"><item type="input">=MULTINOMIAL(F11:H11)</item> returns 1260, if F11 to H11 contain the values <item type="input">2</item>, <item type="input">3</item> and <item type="input">4</item>. This corresponds to the formula =(2+3+4)! / (2!*3!*4!)</paragraph> </section> @@ -831,13 +831,13 @@ <paragraph id="hd_id3155717" role="heading" level="2" xml-lang="en-US">POWER</paragraph> <paragraph id="par_id3159495" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_POTENZ">Returns a number raised to another number.</ahelp></paragraph> -<paragraph id="hd_id3159513" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3159526" role="code" xml-lang="en-US">POWER(Base; Exponent)</paragraph> <paragraph id="par_id3159540" role="paragraph" xml-lang="en-US">Returns <emph>Base</emph> raised to the power of <emph>Exponent</emph>.</paragraph> <paragraph id="par_id5081637" role="paragraph" xml-lang="en-US">The same result may be achieved by using the exponentiation operator ^:</paragraph> <paragraph id="par_id9759514" role="code" xml-lang="en-US"><item type="literal">Base^Exponent</item></paragraph> -<paragraph id="hd_id3159580" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3159594" role="paragraph" xml-lang="en-US"><item type="input">=POWER(4;3)</item> returns 64, which is 4 to the power of 3.</paragraph> <paragraph id="par_id1614429" role="paragraph" xml-lang="en-US">=4^3 also returns 4 to the power of 3.</paragraph><comment>see also EXP, LOG, SQRT</comment> </section> @@ -853,7 +853,7 @@ <paragraph id="par_id3152688" role="paragraph" xml-lang="en-US"><ahelp hid=".">Sums the first terms of a power series.</ahelp></paragraph> <paragraph id="par_id3152708" role="paragraph" xml-lang="en-US">SERIESSUM(x;n;m;coefficients) = coefficient_1*x^n + coefficient_2*x^(n+m) + coefficient_3*x^(n+2m) +...+ coefficient_i*x^(n+(i-1)m)</paragraph> -<paragraph id="hd_id3152724" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_idN11BD9" role="code" xml-lang="en-US">SERIESSUM(X; N; M; Coefficients)</paragraph> <paragraph id="par_id3152737" role="paragraph" xml-lang="en-US"><emph>X</emph> is the input value for the power series.</paragraph> <paragraph id="par_id3144344" role="paragraph" xml-lang="en-US"><emph>N</emph> is the initial power</paragraph> @@ -873,12 +873,12 @@ <paragraph id="hd_id3144386" role="heading" level="2" xml-lang="en-US">PRODUCT</paragraph> <paragraph id="par_id3144414" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_PRODUKT">Multiplies all the numbers given as arguments and returns the product.</ahelp></paragraph> -<paragraph id="hd_id3144433" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3144446" role="code" xml-lang="en-US">PRODUCT(Number1; Number2; ...; Number30)</paragraph> <paragraph id="par_id3144460" role="paragraph" xml-lang="en-US"><emph>Number1 to 30</emph> are up to 30 arguments whose product is to be calculated.</paragraph> <paragraph id="par_id1589098" role="paragraph" xml-lang="en-US">PRODUCT returns number1 * number2 * number3 * ...</paragraph> -<paragraph id="hd_id3144480" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3144494" role="paragraph" xml-lang="en-US"><item type="input">=PRODUCT(2;3;4)</item> returns 24.</paragraph><comment>see also FACT, SUM</comment> </section> @@ -894,11 +894,11 @@ <paragraph id="hd_id3160340" role="heading" level="2" xml-lang="en-US">SUMSQ</paragraph> <paragraph id="par_id3160368" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_QUADRATESUMME">If you want to calculate the sum of the squares of numbers (totaling up of the squares of the arguments), enter these into the text fields.</ahelp></paragraph> -<paragraph id="hd_id3160388" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3160402" role="code" xml-lang="en-US">SUMSQ(Number1; Number2; ...; Number30)</paragraph> <paragraph id="par_id3160415" role="paragraph" xml-lang="en-US"><emph>Number1 to 30</emph> are up to 30 arguments the sum of whose squares is to be calculated.</paragraph> -<paragraph id="hd_id3160436" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3160449" role="paragraph" xml-lang="en-US">If you enter the numbers <item type="input">2</item>; <item type="input">3</item> and <item type="input">4</item> in the Number 1; 2 and 3 text boxes, 29 is returned as the result.</paragraph> </section> @@ -913,12 +913,12 @@ <paragraph id="hd_id3158247" role="heading" level="2" xml-lang="en-US">MOD</paragraph> <paragraph id="par_id3158276" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_REST">Returns the remainder when one integer is divided by another.</ahelp></paragraph> -<paragraph id="hd_id3158294" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3158308" role="code" xml-lang="en-US">MOD(Dividend; Divisor)</paragraph> <paragraph id="par_id3158321" role="paragraph" xml-lang="en-US">For integer arguments this function returns Dividend modulo Divisor, that is the remainder when <emph>Dividend</emph> is divided by <emph>Divisor</emph>.</paragraph> <paragraph id="par_id3158341" role="paragraph" xml-lang="en-US">This function is implemented as <item type="literal">Dividend - Divisor * INT(Dividend/Divisor)</item> , and this formula gives the result if the arguments are not integer.</paragraph> -<paragraph id="hd_id3158361" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3158374" role="paragraph" xml-lang="en-US"><item type="input">=MOD(22;3)</item> returns 1, the remainder when 22 is divided by 3.</paragraph> <paragraph id="par_id1278420" role="paragraph" xml-lang="en-US"><item type="input">=MOD(11.25;2.5)</item> returns 1.25.</paragraph><comment>see also QUOTIENT, INT</comment> </section> @@ -934,12 +934,12 @@ <paragraph id="hd_id3144592" role="heading" level="2" xml-lang="en-US">QUOTIENT</paragraph> <paragraph id="par_id3144627" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_QUOTIENT">Returns the integer part of a division operation.</ahelp></paragraph> -<paragraph id="hd_id3144646" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3144659" role="code" xml-lang="en-US">QUOTIENT(Numerator; Denominator)</paragraph> <paragraph id="par_id9038972" role="paragraph" xml-lang="en-US">Returns the integer part of <emph>Numerator</emph> divided by <emph>Denominator</emph>.</paragraph> <paragraph id="par_id7985168" role="paragraph" xml-lang="en-US">QUOTIENT is equivalent to <item type="literal">INT(numerator/denominator)</item> for same-sign numerator and denominator, except that it may report errors with different error codes. More generally, it is equivalent to <item type="literal">INT(numerator/denominator/SIGN(numerator/denominator))*SIGN(numerator/denominator)</item>.</paragraph> -<paragraph id="hd_id3144674" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3144687" role="paragraph" xml-lang="en-US"><item type="input">=QUOTIENT(11;3)</item> returns 3. The remainder of 2 is lost.</paragraph><comment>see also MOD, INT</comment> </section> @@ -954,11 +954,11 @@ <paragraph id="hd_id3144702" role="heading" level="2" xml-lang="en-US">RADIANS</paragraph> <paragraph id="par_id3158025" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_RAD">Converts degrees to radians.</ahelp></paragraph> -<paragraph id="hd_id3158042" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3158055" role="code" xml-lang="en-US">RADIANS(Number)</paragraph> <paragraph id="par_id3158069" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the angle in degrees to be converted to radians.</paragraph> -<paragraph id="hd_id876186" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3939634" role="paragraph" xml-lang="en-US"><item type="input">=RADIANS(90)</item> returns 1.5707963267949, which is PI/2 to Calc's accuracy.</paragraph><comment>see also DEGREES</comment> </section> @@ -976,12 +976,12 @@ <paragraph id="hd_id3158121" role="heading" level="2" xml-lang="en-US">ROUND</paragraph> <paragraph id="par_id3158150" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_RUNDEN">Rounds a number to a certain number of decimal places.</ahelp></paragraph> -<paragraph id="hd_id3158169" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3158182" role="code" xml-lang="en-US">ROUND(Number; Count)</paragraph> <paragraph id="par_id3158196" role="paragraph" xml-lang="en-US">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 id="par_id599688" role="paragraph" xml-lang="en-US">This function rounds to the nearest number. See ROUNDDOWN and ROUNDUP for alternatives.</paragraph> -<paragraph id="hd_id3145863" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3145876" role="paragraph" xml-lang="en-US"><item type="input">=ROUND(2.348;2)</item> returns 2.35</paragraph> <paragraph id="par_id3145899" role="paragraph" xml-lang="en-US"><item type="input">=ROUND(-32.4834;3)</item> returns -32.483. Change the cell format to see all decimals.</paragraph> <paragraph id="par_id1371501" role="paragraph" xml-lang="en-US"><item type="input">=ROUND(2.348;0)</item> returns 2.</paragraph> @@ -999,12 +999,12 @@ <paragraph id="hd_id3145991" role="heading" level="2" xml-lang="en-US">ROUNDDOWN</paragraph> <paragraph id="par_id3146020" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ABRUNDEN">Rounds a number down, toward zero, to a certain precision.</ahelp></paragraph> -<paragraph id="hd_id3146037" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3146051" role="code" xml-lang="en-US">ROUNDDOWN(Number; Count)</paragraph> <paragraph id="par_id3146064" role="paragraph" xml-lang="en-US">Returns <emph>Number</emph> rounded down (towards zero) to <emph>Count</emph> decimal places. If Count is omitted or zero, the function rounds down to an integer. If Count is negative, the function rounds down to the next 10, 100, 1000, etc.</paragraph> <paragraph id="par_id2188787" role="paragraph" xml-lang="en-US">This function rounds towards zero. See ROUNDUP and ROUND for alternatives.</paragraph> -<paragraph id="hd_id3163164" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3163178" role="paragraph" xml-lang="en-US"><item type="input">=ROUNDDOWN(1.234;2)</item> returns 1.23.</paragraph> <paragraph id="par_id5833307" role="paragraph" xml-lang="en-US"><item type="input">=ROUNDDOWN(45.67;0)</item> returns 45.</paragraph> <paragraph id="par_id7726676" role="paragraph" xml-lang="en-US"><item type="input">=ROUNDDOWN(-45.67)</item> returns -45.</paragraph> @@ -1021,12 +1021,12 @@ <paragraph id="hd_id3163268" role="heading" level="2" xml-lang="en-US">ROUNDUP</paragraph> <paragraph id="par_id3163297" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_AUFRUNDEN">Rounds a number up, away from zero, to a certain precision.</ahelp></paragraph> -<paragraph id="hd_id3163315" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3163328" role="code" xml-lang="en-US">ROUNDUP(Number; Count)</paragraph> <paragraph id="par_id3163342" role="paragraph" xml-lang="en-US">Returns <emph>Number</emph> rounded up (away from zero) to <emph>Count</emph> decimal places. If Count is omitted or zero, the function rounds up to an integer. If Count is negative, the function rounds up to the next 10, 100, 1000, etc.</paragraph> <paragraph id="par_id9573961" role="paragraph" xml-lang="en-US">This function rounds away from zero. See ROUNDDOWN and ROUND for alternatives.</paragraph> -<paragraph id="hd_id3163381" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3144786" role="paragraph" xml-lang="en-US"><item type="input">=ROUNDUP(1.1111;2)</item> returns 1.12.</paragraph> <paragraph id="par_id7700430" role="paragraph" xml-lang="en-US"><item type="input">=ROUNDUP(1.2345;1)</item> returns 1.3.</paragraph> <paragraph id="par_id1180455" role="paragraph" xml-lang="en-US"><item type="input">=ROUNDUP(45.67;0)</item> returns 46.</paragraph> @@ -1044,12 +1044,12 @@ <paragraph id="hd_id5187204" role="heading" level="2" xml-lang="en-US">SEC</paragraph> <paragraph id="par_id9954962" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SECANT">Returns the secant of the given angle (in radians). The secant of an angle is equivalent to 1 divided by the cosine of that angle</ahelp></paragraph> -<paragraph id="hd_id422243" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2055913" role="code" xml-lang="en-US">SEC(Number)</paragraph> <paragraph id="par_id9568170" role="paragraph" xml-lang="en-US">Returns the (trigonometric) secant of <emph>Number</emph>, the angle in radians.</paragraph> <paragraph id="par_id9047465" role="paragraph" xml-lang="en-US">To return the secant of an angle in degrees, use the RADIANS function.</paragraph> -<paragraph id="hd_id9878918" role="heading" level="3" xml-lang="en-US">Examples</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id6935513" role="paragraph" xml-lang="en-US"><item type="input">=SEC(PI()/4)</item> returns approximately 1.4142135624, the inverse of the cosine of PI/4 radians.</paragraph> <paragraph id="par_id3954287" role="paragraph" xml-lang="en-US"><item type="input">=SEC(RADIANS(60))</item> returns 2, the secant of 60 degrees.</paragraph><comment>see also SIN, TAN, COT, CSC, ACOS, ASIN, ATAN, ATAN2, ACOT</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> @@ -1065,11 +1065,11 @@ <paragraph id="hd_id8661934" role="heading" level="2" xml-lang="en-US">SECH</paragraph> <paragraph id="par_id408174" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SECANTHYP">Returns the hyperbolic secant of a number.</ahelp></paragraph> -<paragraph id="hd_id875988" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id4985391" role="code" xml-lang="en-US">SECH(Number)</paragraph> <paragraph id="par_id1952124" role="paragraph" xml-lang="en-US">Returns the hyperbolic secant of <emph>Number</emph>.</paragraph> -<paragraph id="hd_id9838764" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id1187764" role="paragraph" xml-lang="en-US"><item type="input">=SECH(0)</item> returns 1, the hyperbolic secant of 0.</paragraph><comment>see also SINH, TANH, COTH, CSCH, ACOSH, ASINH, ATANH, ACOTH</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> </section> @@ -1084,12 +1084,12 @@ <paragraph id="hd_id3144877" role="heading" level="2" xml-lang="en-US">SIN</paragraph> <paragraph id="par_id3144906" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SIN">Returns the sine of the given angle (in radians).</ahelp></paragraph> -<paragraph id="hd_id3144923" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3144937" role="code" xml-lang="en-US">SIN(Number)</paragraph> <paragraph id="par_id3144950" role="paragraph" xml-lang="en-US">Returns the (trigonometric) sine of <emph>Number</emph>, the angle in radians.</paragraph> <paragraph id="par_id8079470" role="paragraph" xml-lang="en-US">To return the sine of an angle in degrees, use the RADIANS function.</paragraph> -<paragraph id="hd_id3144969" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3144983" role="paragraph" xml-lang="en-US"><item type="input">=SIN(PI()/2)</item> returns 1, the sine of PI/2 radians.</paragraph> <paragraph id="par_id3916440" role="paragraph" xml-lang="en-US"><item type="input">=SIN(RADIANS(30))</item> returns 0.5, the sine of 30 degrees.</paragraph><comment>see also COS, TAN, COT, ACOS, ASIN, ATAN, ATAN2, ACOT</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> @@ -1105,11 +1105,11 @@ <paragraph id="hd_id3163397" role="heading" level="2" xml-lang="en-US">SINH</paragraph> <paragraph id="par_id3163426" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SINHYP">Returns the hyperbolic sine of a number.</ahelp></paragraph> -<paragraph id="hd_id3163444" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3163457" role="code" xml-lang="en-US">SINH(Number)</paragraph> <paragraph id="par_id3163471" role="paragraph" xml-lang="en-US">Returns the hyperbolic sine of <emph>Number</emph>.</paragraph> -<paragraph id="hd_id3163491" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3163504" role="paragraph" xml-lang="en-US"><item type="input">=SINH(0)</item> returns 0, the hyperbolic sine of 0.</paragraph><comment>see also COSH, TANH, COTH, ACOSH, ASINH, ATANH, ACOTH</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> </section> @@ -1125,11 +1125,11 @@ <paragraph id="hd_id3163596" role="heading" level="2" xml-lang="en-US"><variable id="sum_head"><link href="text/scalc/01/04060106.xhp#Section16">SUM</link></variable></paragraph> <paragraph id="par_id3163625" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMME">Adds all the numbers in a range of cells.</ahelp></paragraph> -<paragraph id="hd_id3163643" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3163656" role="code" xml-lang="en-US">SUM(Number1; Number2; ...; Number30)</paragraph> <paragraph id="par_id3163671" role="paragraph" xml-lang="en-US"><emph>Number 1 to Number 30</emph> are up to 30 arguments whose sum is to be calculated.</paragraph> -<paragraph id="hd_id3163690" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3163704" role="paragraph" xml-lang="en-US">If you enter the numbers <item type="input">2</item>; <item type="input">3 </item>and <item type="input">4</item> in the Number 1; 2 and 3 text boxes, 9 will be returned as the result.</paragraph> <paragraph id="par_id3151740" role="paragraph" xml-lang="en-US"><item type="input">=SUM(A1;A3;B5)</item> calculates the sum of the three cells. <item type="input">=SUM (A1:E10)</item> calculates the sum of all cells in the A1 to E10 cell range.</paragraph> <paragraph id="par_id3151756" role="paragraph" xml-lang="en-US">Conditions linked by AND can be used with the function SUM() in the following manner:</paragraph> @@ -1154,14 +1154,14 @@ <paragraph id="par_id3151986" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_SUMMEWENN">Adds the cells specified by a given criteria.</ahelp> This function is used to browse a range when you search for a certain value.</paragraph> <embed href="text/shared/00/00000001.xhp#regulaer"/> -<paragraph id="hd_id3152015" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3152028" role="code" xml-lang="en-US">SUMIF(Range; Criteria; SumRange)</paragraph> <paragraph id="par_id3152043" role="paragraph" xml-lang="en-US"><emph>Range</emph> is the range to which the criteria are to be applied.</paragraph> <paragraph id="par_id3152062" role="paragraph" xml-lang="en-US"><emph>Criteria</emph> is the cell in which the search criterion is shown, or the search criterion itself. If the criteria is written into the formula, it has to be surrounded by double quotes.</paragraph> <paragraph id="par_id3152083" role="paragraph" xml-lang="en-US"><emph>SumRange</emph> is the range from which values are summed. If this parameter has not been indicated, the values found in the Range are summed.</paragraph> <paragraph id="par_id8347422" role="note" xml-lang="en-US">SUMIF supports the reference concatenation operator (~) only in the Criteria parameter, and only if the optional SumRange parameter is not given.</paragraph> -<paragraph id="hd_id3152110" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3152148" role="paragraph" xml-lang="en-US">To sum up only negative numbers: <item type="input">=SUMIF(A1:A10;"<0")</item></paragraph> <paragraph id="par_id6670125" role="paragraph" xml-lang="en-US"><item type="input">=SUMIF(A1:A10;">0";B1:10)</item> - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0.</paragraph> <paragraph id="par_id6062196" role="paragraph" xml-lang="en-US">See COUNTIF() for some more syntax examples that can be used with SUMIF().</paragraph> @@ -1187,12 +1187,12 @@ <paragraph id="hd_id3152195" role="heading" level="2" xml-lang="en-US">TAN</paragraph> <paragraph id="par_id3152224" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_TAN">Returns the tangent of the given angle (in radians).</ahelp></paragraph> -<paragraph id="hd_id3152242" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3152255" role="code" xml-lang="en-US">TAN(Number)</paragraph> <paragraph id="par_id3152269" role="paragraph" xml-lang="en-US">Returns the (trigonometric) tangent of <emph>Number</emph>, the angle in radians.</paragraph> <paragraph id="par_id5752128" role="paragraph" xml-lang="en-US">To return the tangent of an angle in degrees, use the RADIANS function.</paragraph> -<paragraph id="hd_id3152287" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3152301" role="paragraph" xml-lang="en-US"><item type="input">=TAN(PI()/4) </item>returns 1, the tangent of PI/4 radians.</paragraph> <paragraph id="par_id1804864" role="paragraph" xml-lang="en-US"><item type="input">=TAN(RADIANS(45))</item> returns 1, the tangent of 45 degrees.</paragraph><comment>see also COS, SIN, COT, ACOS, ASIN, ATAN, ATAN2, ACOT</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> @@ -1208,11 +1208,11 @@ <paragraph id="hd_id3165434" role="heading" level="2" xml-lang="en-US">TANH</paragraph> <paragraph id="par_id3165462" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_TANHYP">Returns the hyperbolic tangent of a number.</ahelp></paragraph> -<paragraph id="hd_id3165480" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3165494" role="code" xml-lang="en-US">TANH(Number)</paragraph> <paragraph id="par_id3165508" role="paragraph" xml-lang="en-US">Returns the hyperbolic tangent of <emph>Number</emph>.</paragraph> -<paragraph id="hd_id3165527" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3165541" role="paragraph" xml-lang="en-US"><item type="input">=TANH(0)</item> returns 0, the hyperbolic tangent of 0.</paragraph><comment>see also COSH, SINH, COTH, ACOSH, ASINH, ATANH, ACOTH</comment> <embed href="text/scalc/06/calcsamplefiles.xhp#trigon"/> </section> @@ -1230,7 +1230,7 @@ <paragraph id="hd_id3165633" role="heading" level="2" xml-lang="en-US">SUBTOTAL</paragraph> <paragraph id="par_id3165682" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_TEILERGEBNIS">Calculates subtotals.</ahelp> If a range already contains subtotals, these are not used for further calculations. Use this function with the AutoFilters to take only the filtered records into account.</paragraph> -<paragraph id="hd_id3165704" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3165717" role="code" xml-lang="en-US">SUBTOTAL(Function; Range)</paragraph> <paragraph id="par_id3165731" role="paragraph" xml-lang="en-US"><emph>Function</emph> is a number that stands for one of the following functions:</paragraph> @@ -1374,7 +1374,7 @@ <paragraph id="par_id20082017075115609" role="paragraph" xml-lang="en-US">Use numbers 1-11 to include manually hidden rows or 101-111 to exclude them; filtered-out cells are always excluded.</paragraph> <paragraph id="par_id3143606" role="paragraph" xml-lang="en-US"><emph>Range</emph> is the range whose cells are included.</paragraph> -<paragraph id="hd_id3143625" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3143638" role="paragraph" xml-lang="en-US">You have a table in the cell range A1:B6 containing a bill of material for 10 students. Row 2 (Pen) is manually hidden. You want to see the sum of the figures that are displayed; that is, just the subtotal for the filtered rows. In this case the correct formula would be:</paragraph> <table id="tbl_200820170737188127"> @@ -1473,7 +1473,7 @@ <paragraph id="hd_id3143672" role="heading" level="2" xml-lang="en-US">EUROCONVERT<comment>insert link in financial</comment></paragraph> <paragraph id="par_id3143708" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_UMRECHNEN">Converts between old European national currency and to and from Euros.</ahelp></paragraph> -<paragraph id="par_id3143731" role="heading" level="3" xml-lang="en-US"><emph>Syntax</emph></paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3143748" role="code" xml-lang="en-US">EUROCONVERT(Value; "From_currency"; "To_currency", full_precision, triangulation_precision)</paragraph> <paragraph id="par_id3143763" role="paragraph" xml-lang="en-US"><emph>Value</emph> is the amount of the currency to be converted.</paragraph> <paragraph id="par_id3143782" role="paragraph" xml-lang="en-US"><emph>From_currency</emph> and <emph>To_currency</emph> are the currency units to convert from and to respectively. These must be text, the official abbreviation for the currency (for example, "EUR"). The rates (shown per Euro) were set by the European Commission.</paragraph> @@ -1496,10 +1496,10 @@ <paragraph id="par_id0908200902131122" role="paragraph" xml-lang="en-US"><ahelp hid=".">Converts a value from one unit of measurement to another unit of measurement. The conversion factors are given in a list in the configuration.</ahelp></paragraph> <paragraph id="par_id0908200902475420" role="paragraph" xml-lang="en-US">At one time the list of conversion factors included the legacy European currencies and the Euro (see examples below). We suggest using the new function EUROCONVERT for converting these currencies.</paragraph> -<paragraph id="hd_id0908200902131071" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id0908200902131191" role="code" xml-lang="en-US">CONVERT_OOO(value;"text";"text")</paragraph> -<paragraph id="hd_id0908200902131152" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id090820090213112" role="paragraph" xml-lang="en-US"><item type="input">=CONVERT_OOO(100;"ATS";"EUR")</item> returns the Euro value of 100 Austrian Schillings.</paragraph> <paragraph id="par_id0908200902475431" role="paragraph" xml-lang="en-US">=CONVERT_OOO(100;"EUR";"DEM") converts 100 Euros into German Marks.</paragraph> </section> @@ -1515,11 +1515,11 @@ <paragraph id="hd_id3157177" role="heading" level="2" xml-lang="en-US">ODD</paragraph> <paragraph id="par_id3157205" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_UNGERADE">Rounds a positive number up to the nearest odd integer and a negative number down to the nearest odd integer.</ahelp></paragraph> -<paragraph id="hd_id3157223" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3157237" role="code" xml-lang="en-US">ODD(Number)</paragraph> <paragraph id="par_id3157250" role="paragraph" xml-lang="en-US">Returns <emph>Number</emph> rounded to the next odd integer up, away from zero.</paragraph> -<paragraph id="hd_id3157270" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3157283" role="paragraph" xml-lang="en-US"><item type="input">=ODD(1.2)</item> returns 3.</paragraph> <paragraph id="par_id8746910" role="paragraph" xml-lang="en-US"><item type="input">=ODD(1)</item> returns 1.</paragraph> <paragraph id="par_id9636524" role="paragraph" xml-lang="en-US"><item type="input">=ODD(0)</item> returns 1.</paragraph> @@ -1537,12 +1537,12 @@ <paragraph id="hd_id2957404" role="heading" level="2" xml-lang="en-US">FLOOR.PRECISE</paragraph> <paragraph id="par_id2957432" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FLOOR_MS">Rounds a number down to the nearest multiple of Significance, regardless of sign of Significance</ahelp></paragraph> -<paragraph id="hd_id2957451" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id2957464" role="code" xml-lang="en-US">FLOOR.PRECISE(Number; Significance)</paragraph> <paragraph id="par_id2957478" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded down.</paragraph> <paragraph id="par_id2957497" role="paragraph" xml-lang="en-US"><emph>Significance</emph> is the value to whose multiple the number is to be rounded down.</paragraph> -<paragraph id="hd_id2963932" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id2963945" role="paragraph" xml-lang="en-US"><item type="input">=FLOOR.PRECISE( -11;-2)</item> returns -12</paragraph><comment>see also CEILING, EVEN, ODD, MROUND,INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> </section> @@ -1557,14 +1557,14 @@ <paragraph id="hd_id3157404" role="heading" level="2" xml-lang="en-US">FLOOR</paragraph> <paragraph id="par_id3157432" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_UNTERGRENZE">Rounds a number down to the nearest multiple of Significance.</ahelp></paragraph> -<paragraph id="hd_id3157451" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3157464" role="code" xml-lang="en-US">FLOOR(Number; Significance; Mode)</paragraph> <paragraph id="par_id3157478" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the number that is to be rounded down.</paragraph> <paragraph id="par_id3157497" role="paragraph" xml-lang="en-US"><emph>Significance</emph> is the value to whose multiple the number is to be rounded down.</paragraph> <paragraph id="par_id3157517" 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 towards zero. If the Mode value is equal to zero or is not given, negative numbers are rounded away from zero.</paragraph> <paragraph id="par_id3163894" role="warning" xml-lang="en-US">If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that exists since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that exists since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions. Note that FLOOR.XCL always rounds towards zero.</paragraph> -<paragraph id="hd_id3163932" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3163945" role="paragraph" xml-lang="en-US"><item type="input">=FLOOR( -11;-2)</item> returns -12</paragraph> <paragraph id="par_id3163966" role="paragraph" xml-lang="en-US"><item type="input">=FLOOR( -11;-2;0)</item> returns -12</paragraph> <paragraph id="par_id3163988" role="paragraph" xml-lang="en-US"><item type="input">=FLOOR( -11;-2;1)</item> returns -10</paragraph><comment>see also CEILING, EVEN, ODD, MROUND, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> @@ -1581,11 +1581,11 @@ <paragraph id="hd_id3164086" role="heading" level="2" xml-lang="en-US">SIGN</paragraph> <paragraph id="par_id3164115" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_VORZEICHEN">Returns the sign of a number. Returns 1 if the number is positive, -1 if negative and 0 if zero.</ahelp></paragraph> -<paragraph id="hd_id3164136" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3164150" role="code" xml-lang="en-US">SIGN(Number)</paragraph> <paragraph id="par_id3164164" role="paragraph" xml-lang="en-US"><emph>Number</emph> is the number whose sign is to be determined.</paragraph> -<paragraph id="hd_id3164183" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3164197" role="paragraph" xml-lang="en-US"><item type="input">=SIGN(3.4)</item> returns 1.</paragraph> <paragraph id="par_id3164212" role="paragraph" xml-lang="en-US"><item type="input">=SIGN(-4.5)</item> returns -1.</paragraph><comment>see also ABS</comment> </section> @@ -1601,12 +1601,12 @@ <paragraph id="hd_id3164252" role="heading" level="2" xml-lang="en-US">MROUND</paragraph> <paragraph id="par_id3164288" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_MROUND">Returns a number rounded to the nearest multiple of another number.</ahelp></paragraph> -<paragraph id="hd_id3164306" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3164320" role="code" xml-lang="en-US">MROUND(Number; Multiple)</paragraph> <paragraph id="par_id3486434" role="paragraph" xml-lang="en-US">Returns <emph>Number</emph> rounded to the nearest multiple of <emph>Multiple</emph>.</paragraph> <paragraph id="par_id3068636" role="paragraph" xml-lang="en-US">An alternative implementation would be <item type="literal">Multiple * ROUND(Number/Multiple)</item>.</paragraph> -<paragraph id="hd_id3164333" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3164347" role="paragraph" xml-lang="en-US"><item type="input">=MROUND(15.5;3)</item> returns 15, as 15.5 is closer to 15 (= 3*5) than to 18 (= 3*6).</paragraph> <paragraph id="par_idN14DD6" role="paragraph" xml-lang="en-US"><item type="input">=MROUND(1.4;0.5)</item> returns 1.5 (= 0.5*3).</paragraph><comment>see also CEILING, FLOOR, EVEN, ODD, INT, TRUNC, ROUND, ROUNDDOWN, ROUNDUP</comment> </section> @@ -1622,12 +1622,12 @@ <paragraph id="hd_id3164375" role="heading" level="2" xml-lang="en-US">SQRT</paragraph> <paragraph id="par_id3164404" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_WURZEL">Returns the positive square root of a number.</ahelp></paragraph> -<paragraph id="hd_id3164424" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3164437" role="code" xml-lang="en-US">SQRT(Number)</paragraph> <paragraph id="par_id3164451" role="paragraph" xml-lang="en-US">Returns the positive square root of <emph>Number</emph>.</paragraph> <paragraph id="par_id6870021" role="paragraph" xml-lang="en-US">Number must be positive.</paragraph> -<paragraph id="hd_id3164471" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3164484" role="paragraph" xml-lang="en-US"><item type="input">=SQRT(16)</item> returns 4.</paragraph> <paragraph id="par_id3591723" role="paragraph" xml-lang="en-US"><item type="input">=SQRT(-16)</item> returns an <item type="literal">invalid argument</item> error.</paragraph><comment>see also SQRTPI, POWER</comment> </section> @@ -1643,12 +1643,12 @@ <paragraph id="hd_id3164560" role="heading" level="2" xml-lang="en-US">SQRTPI</paragraph> <paragraph id="par_id3164596" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_SQRTPI">Returns the square root of (PI times a number).</ahelp></paragraph> -<paragraph id="hd_id3164614" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3164627" role="code" xml-lang="en-US">SQRTPI(Number)</paragraph> <paragraph id="par_id1501510" role="paragraph" xml-lang="en-US">Returns the positive square root of (PI multiplied by <emph>Number</emph>).</paragraph> <paragraph id="par_id9929197" role="paragraph" xml-lang="en-US">This is equivalent to <item type="literal">SQRT(PI()*Number)</item>.</paragraph> -<paragraph id="hd_id3164641" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3164654" role="paragraph" xml-lang="en-US"><item type="input">=SQRTPI(2)</item> returns the squareroot of (2PI), approximately 2.506628.</paragraph><comment>see also SQRT</comment> </section> @@ -1663,14 +1663,14 @@ <paragraph id="hd_id3164669" role="heading" level="2" xml-lang="en-US">RANDBETWEEN</paragraph> <paragraph id="par_id3164711" role="paragraph" xml-lang="en-US"><ahelp hid="HID_AAI_FUNC_RANDBETWEEN">Returns an integer random number in a specified range.</ahelp></paragraph> -<paragraph id="hd_id3164745" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3164758" role="code" xml-lang="en-US">RANDBETWEEN(Bottom; Top)</paragraph> <paragraph id="par_id7112338" role="paragraph" xml-lang="en-US">Returns an integer random number between integers <emph>Bottom</emph> and <emph>Top</emph> (both inclusive).</paragraph> <paragraph id="par_id2855616" role="paragraph" xml-lang="en-US">This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press Shift+<switchinline select="sys"><caseinline select="MAC">Command </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+F9.</paragraph> <paragraph id="par_id2091433" role="paragraph" xml-lang="en-US">To generate random numbers which never recalculate, copy cells containing this function, and use <item type="menuitem">Edit - Paste Special</item> (with <item type="menuitem">Paste All</item> and <item type="menuitem">Formulas</item> not marked and <item type="menuitem">Numbers</item> marked).</paragraph> -<paragraph id="hd_id3164772" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id3164785" role="paragraph" xml-lang="en-US"><item type="input">=RANDBETWEEN(20;30)</item> returns an integer of between 20 and 30.</paragraph><comment>see also RAND</comment> </section> @@ -1685,12 +1685,12 @@ <paragraph id="hd_id3164800" role="heading" level="2" xml-lang="en-US">RAND</paragraph> <paragraph id="par_id3164829" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ZUFALLSZAHL">Returns a random number between 0 and 1.</ahelp><comment>The value of 0 can be returned, the value of 1 not.</comment><comment>this is really true after issue 53642 will be fixed</comment></paragraph> -<paragraph id="hd_id3164870" role="heading" level="3" xml-lang="en-US">Syntax</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph id="par_id3164884" role="code" xml-lang="en-US">RAND()</paragraph> <paragraph id="par_id5092318" role="paragraph" xml-lang="en-US">This function produces a new random number each time Calc recalculates. To force Calc to recalculate manually press F9.</paragraph> <paragraph id="par_id9312417" role="paragraph" xml-lang="en-US">To generate random numbers which never recalculate, copy cells each containing =RAND(), and use <item type="menuitem">Edit - Paste Special</item> (with <item type="menuitem">Paste All</item> and <item type="menuitem">Formulas</item> not marked and <item type="menuitem">Numbers</item> marked).</paragraph> -<paragraph id="hd_id9089022" role="heading" level="3" xml-lang="en-US">Example</paragraph> +<embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id9569078" role="paragraph" xml-lang="en-US"><item type="input">=RAND()</item> returns a random number between 0 and 1.</paragraph><comment>see also RANDBETWEEN</comment> </section> </sort> |