diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-07-12 16:34:34 +0200 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-07-15 02:23:33 +0200 |
| commit | 15790ee596f22dcea3ddcdacdc56113ec54b63f3 (patch) | |
| tree | 4e778cd6b578d8c5682a4d0fc40dda8daffd20f6 | |
| parent | 821b9724fe32e7e890c1ebe1d36f792bc3839fb0 (diff) | |
Clarify example for SWITCH
...But the function need a date in A3 instead of a number.
So in my opinion the string should be:
<input>=SWITCH(MONTH(A3),1,"January",2,"February",3,"March","No match")</input> returns "January" when A3 contains a date in January, "February" when A3 contains a date in February , etc...
Change-Id: I2702d569f1c43080cd4c137a4d100111edc55863
Reviewed-on: https://gerrit.libreoffice.org/75499
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
| -rw-r--r-- | source/text/scalc/01/func_switch.xhp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/source/text/scalc/01/func_switch.xhp b/source/text/scalc/01/func_switch.xhp index 36178c1be6..2c162d2ae5 100644 --- a/source/text/scalc/01/func_switch.xhp +++ b/source/text/scalc/01/func_switch.xhp @@ -33,7 +33,7 @@ <paragraph role="paragraph" id="par_id331556245422283"><emph>default_result</emph>: any value or reference to a cell that is returned when there is no match.</paragraph> <paragraph role="paragraph" id="par_id871556243022881">If no <emph>value</emph> equals <emph>expression</emph> and no default result is given, a #N/A error is returned.</paragraph> <embed href="text/scalc/01/ful_func.xhp#func_head_example"/> - <paragraph role="paragraph" id="par_id851556243961783"><input>=SWITCH(MONTH(A3),1,"January",2,"February",3,"March","No match")</input> returns "January" when A3=1, February when A3=2 , etc...</paragraph> + <paragraph role="paragraph" id="par_id851556243961783"><input>=SWITCH(MONTH(A3),1,"January",2,"February",3,"March","No match")</input> returns "January" when A3 contains a date in January, "February" when A3 contains a date in February , etc...</paragraph> <section id="relatedtopics"> <embed href="text/scalc/01/func_ifs.xhp#ifsfunct"/> <paragraph role="paragraph" id="par_id781556244709752"><link href="text/scalc/01/04060105.xhp#Section4" name="if">IF</link></paragraph> |