source/text/scalc/01/func_minifs.xhp | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
New commits:
commit c5873df9d618a297c3fd0e5cbd77aed5025a22b5
Author: Steve Fanning <stevemfann...@yahoo.co.uk>
AuthorDate: Mon Feb 1 11:46:57 2021 +0100
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Feb 1 13:30:42 2021 +0100
Fix typos in Help description of Calc’s MINIFS function.
Specifically, in the section entitled “Using regular expressions and nested
functions”.
Affects file func_minifs.xhp.
Change-Id: I843c13711c4eac7174ec3e3c500a2a52c65b9c40
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110224
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/func_minifs.xhp
b/source/text/scalc/01/func_minifs.xhp
index 2fbb087a1..096e404fb 100644
--- a/source/text/scalc/01/func_minifs.xhp
+++ b/source/text/scalc/01/func_minifs.xhp
@@ -47,9 +47,9 @@
<paragraph id="par_id189772445525114" role="paragraph"
xml-lang="en-US">Calculates the minimum of values of the range C2:C6 that are
lower than 90 and correspond to cells of the B2:B6 range with values greater
than or equal to 20. Returns 190.</paragraph>
<h4 id="hd_id30455222431067">Using regular expressions and nested
functions</h4>
<paragraph id="par_id307691022525348" role="paragraph" xml-lang="en-US"><item
type="input">=MINIFS(C2:C6;B2:B6;">"&MIN(B2:B6);B2:B6;"<"&MAX(B2:B6))</item></paragraph>
-<paragraph id="par_id27619246864839" role="paragraph"
xml-lang="en-US">Calculates the minimum of values of the range C2:C6 that
correspond to all values of the range B2:B6 except its minimum and minimum.
Returns 65.</paragraph>
-<paragraph id="par_id220502883332563" role="paragraph" xml-lang="en-US"><item
type="input">=MINIFS(C2:C6;A2:A6;".*book";B2:B6;"<="&MAX(B2:B6))</item></paragraph>
-<paragraph id="par_id15342189586295" role="paragraph"
xml-lang="en-US">Calculates the minimum of values of the range C2:C6 that
correspond to all cells of the A2:A6 range starting with "pen" and to all cells
of the B2:B6 range except its minimum. Returns 180.</paragraph>
+<paragraph id="par_id27619246864839" role="paragraph"
xml-lang="en-US">Calculates the minimum of values of the range C2:C6 that
correspond to all values of the range B2:B6 except its minimum and maximum.
Returns 65.</paragraph>
+<paragraph id="par_id220502883332563" role="paragraph" xml-lang="en-US"><item
type="input">=MINIFS(C2:C6;A2:A6;".*book";B2:B6;">"&MIN(B2:B6))</item></paragraph>
+<paragraph id="par_id15342189586295" role="paragraph"
xml-lang="en-US">Calculates the minimum of values of the range C2:C6 that
correspond to all cells of the A2:A6 range ending with "book" and to all cells
of the B2:B6 range except its minimum. Returns 190.</paragraph>
<h4 id="hd_id8168283329426">Reference to a cell as a criterion</h4>
<paragraph id="par_id50762995519951" role="paragraph" xml-lang="en-US">If you
need to change a criterion easily, you may want to specify it in a separate
cell and use a reference to this cell in the condition of the MINIFS function.
For example, the above function can be rewritten as follows:</paragraph>
<paragraph id="par_id135761606425300" role="paragraph" xml-lang="en-US"><item
type="input">=MINIFS(C2:C6;A2:A6;".*"&E2;B2:B6;"<"&MAX(B2:B6))</item></paragraph>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
