source/text/scalc/01/func_switch.xhp | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 8e34671f7dc259bac69350f8cf6d0ec0cbfad7c1
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Fri Jul 12 16:34:34 2019 +0200
Commit: Eike Rathke <er...@redhat.com>
CommitDate: Thu Sep 5 16:38:51 2019 +0200
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.sop...@gmail.com>
Reviewed-by: Eike Rathke <er...@redhat.com>
diff --git a/source/text/scalc/01/func_switch.xhp
b/source/text/scalc/01/func_switch.xhp
index 36178c1be..84a5b365a 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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
