source/text/scalc/01/func_minifs.xhp | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-)
New commits: commit bd88e80374d12024de5ae94494a7c14840e09ee4 Author: Julien Nabet <[email protected]> AuthorDate: Sun May 10 14:58:29 2026 +0200 Commit: Julien Nabet <[email protected]> CommitDate: Sun May 10 15:08:12 2026 +0200 tdf#172035: fix MINFS doc Change-Id: If4cd3f22eaad44a142899ecebf71aa2b23ef4ccb Reviewed-on: https://gerrit.libreoffice.org/c/help/+/205026 Tested-by: Jenkins Reviewed-by: Julien Nabet <[email protected]> diff --git a/source/text/scalc/01/func_minifs.xhp b/source/text/scalc/01/func_minifs.xhp index 4f0fc46e66..1c412fceeb 100644 --- a/source/text/scalc/01/func_minifs.xhp +++ b/source/text/scalc/01/func_minifs.xhp @@ -41,9 +41,9 @@ <h4 id="hd_id193452436229521">Simple usage</h4> <paragraph id="par_id94321051525036" role="paragraph"><item type="input">=MINIFS(B2:B6;B2:B6;"<35")</item></paragraph> -<paragraph id="par_id28647227259438" role="paragraph">Calculates the minimum of values of the range B2:B6 that are lower than or equal to 20. Returns 17.</paragraph> +<paragraph id="par_id28647227259438" role="paragraph">Calculates the minimum of values of the range B2:B6 that are lower than or equal to 35. Returns 17.</paragraph> <paragraph id="par_id36952767622741" role="paragraph"><item type="input">=MINIFS(C2:C6;B2:B6;">=20";C2:C6;">90")</item></paragraph> -<paragraph id="par_id189772445525114" role="paragraph">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> +<paragraph id="par_id189772445525114" role="paragraph">Calculates the minimum of values of the range C2:C6 that are greater 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"><item type="input">=MINIFS(C2:C6;B2:B6;">"&MIN(B2:B6);B2:B6;"<"&MAX(B2:B6))</item></paragraph> <paragraph id="par_id27619246864839" role="paragraph">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>
