diff options
| author | Steve Fanning <stevemfanning.wh@gmail.com> | 2020-03-30 11:56:38 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-03-30 21:30:35 +0200 |
| commit | 2c5b14255f07ae7eba46155558555a1c2011dacf (patch) | |
| tree | a5d709852f9ca533ee219aae680af18d0d39cf72 /source/text/scalc/01/04060106.xhp | |
| parent | 623fc3fb5692577ea4fe3c01ea4b909df1d6d536 (diff) | |
tdf#131360 Adjust number of function parameters
fix for AGGREGATE, GCD_EXCEL2003, LCM_EXCEL2003
MULTINOMIAL, RAWSUBTRACT, SUMIFS, AVERAGEIFS, COUNTIFS,
MAXIFS, MINIFS, IFS, SWITCH
Change-Id: Id652cdf52a795cd675e7717f856a2745be7d9f52
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/91373
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 | 24 |
1 files changed, 6 insertions, 18 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp index 94bef60362..a34aba2f39 100644 --- a/source/text/scalc/01/04060106.xhp +++ b/source/text/scalc/01/04060106.xhp @@ -515,17 +515,13 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3151221"> <bookmark_value>GCD_EXCEL2003 function</bookmark_value> </bookmark> - <bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_GCD" id="bm_id3147578" localize="false"/> - <h2 id="hd_id3151221">GCD_EXCEL2003</h2> <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"/> - <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="par_id3156205" role="code" xml-lang="en-US">GCD_EXCEL2003(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> +<embed href="text/scalc/01/ful_func.xhp#number255"/> <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> @@ -554,17 +550,13 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3154230"> <bookmark_value>LCM_EXCEL2003 function</bookmark_value> </bookmark> - <bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_LCM" id="bm_id3147222" localize="false"/> - <h2 id="hd_id3154230">LCM_EXCEL2003</h2> <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"/> - <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="par_id3154395" role="code" xml-lang="en-US">LCM_EXCEL2003(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> +<embed href="text/scalc/01/ful_func.xhp#number255"/> <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> @@ -817,16 +809,12 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3152418"> <bookmark_value>MULTINOMIAL function</bookmark_value> </bookmark> - <bookmark xml-lang="en-US" branch="hid/SC_HID_AAI_FUNC_MULTINOMIAL" id="bm_id3152429" localize="false"/> - <h2 id="hd_id3152418">MULTINOMIAL</h2> <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> - <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="par_id3155660" role="code" xml-lang="en-US">MULTINOMIAL(<embedvar href="text/scalc/01/ful_func.xhp#number255_1" markup="keep"/>)</paragraph> +<embed href="text/scalc/01/ful_func.xhp#number255"/> <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> |