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/func_switch.xhp | |
| parent | Remove empty heading. (diff) | |
| download | help-2c5b14255f07ae7eba46155558555a1c2011dacf.tar.gz help-2c5b14255f07ae7eba46155558555a1c2011dacf.zip | |
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/func_switch.xhp')
| -rw-r--r-- | source/text/scalc/01/func_switch.xhp | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/source/text/scalc/01/func_switch.xhp b/source/text/scalc/01/func_switch.xhp index 2c162d2ae5..f337953c94 100644 --- a/source/text/scalc/01/func_switch.xhp +++ b/source/text/scalc/01/func_switch.xhp @@ -26,7 +26,9 @@ </section> <embed href="text/scalc/00/avail_release.xhp#5.2"/> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> - <paragraph role="code" id="par_id521556242803283">SWITCH( expression, value1, result1[, value2, result2][, … ][, default_result] )</paragraph> + + <paragraph role="code" id="par_id521556242803283">SWITCH(expression; value1; result1[; value2; result2][; ... ; [value127; result127][; default_result]])</paragraph> + <tip id="par_id111585520651521">If you choose not to specify a default result, 127 value / result pairs may be entered as parameters. If you choose to include a default result at the end of the list of parameters, then only 126 value / result pairs may be entered.</tip> <paragraph role="paragraph" id="par_id341556242996378"><emph>expression</emph> is a text, numeric, logical or date input or reference to a cell.</paragraph> <paragraph role="paragraph" id="par_id321556243790332"><emph>value1, value2, ...</emph> is any value or reference to a cell. Each value must have a result given.</paragraph> <paragraph role="paragraph" id="par_id171556243796068"><emph>result1, result2, ...</emph> is any value or reference to a cell.</paragraph> |