diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2019-07-12 16:34:34 +0200 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2019-09-05 16:38:51 +0200 |
| commit | 8e34671f7dc259bac69350f8cf6d0ec0cbfad7c1 (patch) | |
| tree | 21737a64c357965ba4398c3aa9e5741fe9e69ad0 | |
| parent | e3eddb614cf11d3bd383669a13bbbbfef0bf9f80 (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/75500
Tested-by: Jenkins
Reviewed-by: Sophie Gautier <gautier.sophie@gmail.com>
Reviewed-by: Eike Rathke <erack@redhat.com>
| -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..84a5b365a4 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> |