diff options
Diffstat (limited to 'source/text/scalc/01/func_minifs.xhp')
| -rw-r--r-- | source/text/scalc/01/func_minifs.xhp | 41 |
1 files changed, 21 insertions, 20 deletions
diff --git a/source/text/scalc/01/func_minifs.xhp b/source/text/scalc/01/func_minifs.xhp index 25a95b3e2b..4f0fc46e66 100644 --- a/source/text/scalc/01/func_minifs.xhp +++ b/source/text/scalc/01/func_minifs.xhp @@ -11,47 +11,48 @@ <meta> <topic id="textscalc01func_minifsxml" indexer="include" status="PUBLISH"> - <title id="tit" xml-lang="en-US">MINIFS function</title> + <title id="tit">MINIFS function</title> <filename>/text/scalc/01/func_minifs.xhp</filename> </topic> </meta> <body> <section id="minifs_function"> -<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MINIFS" id="bm_id657666576665766" localize="false"/> -<bookmark xml-lang="en-US" branch="index" id="bm_id658066580665806"> +<bookmark branch="hid/SC_HID_FUNC_MINIFS" id="bm_id657666576665766" localize="false"/> +<bookmark branch="index" id="bm_id658066580665806"> <bookmark_value>MINIFS function</bookmark_value> <bookmark_value>minimum;satisfying conditions</bookmark_value> </bookmark> <h1 id="hd_id658866588665886"><variable id="minifs_head"><link href="text/scalc/01/func_minifs.xhp">MINIFS</link></variable> function</h1> -<paragraph id="par_id659756597565975" role="paragraph" xml-lang="en-US"><ahelp hid="."><variable id="minifs_des">Returns the minimum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp></paragraph> +<paragraph id="par_id659756597565975" role="paragraph"><ahelp hid="."><variable id="minifs_des">Returns the minimum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp></paragraph> </section> <embed href="text/scalc/01/ful_func.xhp#func_head_syntax"/> -<paragraph id="par_id11655988824213" role="code" xml-lang="en-US">MINIFS(<embedvar href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph> +<paragraph id="par_id11655988824213" role="code">MINIFS(<embedvar href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph> -<paragraph id="par_id59901690530236" role="paragraph" xml-lang="en-US"><emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the minimum.</paragraph> +<paragraph id="par_id59901690530236" role="paragraph"><emph>Func_Range</emph> – required argument. A range of cells, a name of a named range or a label of a column or a row containing values for calculating the minimum.</paragraph> <embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/> <embed href="text/shared/00/00000001.xhp#regex"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#warning01"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/> +<embed href="text/scalc/01/ful_func.xhp#func_head_example"/> <embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/> <h4 id="hd_id193452436229521">Simple usage</h4> -<paragraph id="par_id94321051525036" role="paragraph" xml-lang="en-US"><item type="input">=MINIFS(B2:B6;B2:B6;"<35")</item></paragraph> -<paragraph id="par_id28647227259438" role="paragraph" xml-lang="en-US">Calculates the minimum of values of the range B2:B6 that are lower than or equal to 20. Returns 17.</paragraph> -<paragraph id="par_id36952767622741" role="paragraph" xml-lang="en-US"><item type="input">=MINIFS(C2:C6;B2:B6;">=20";C2:C6;">90")</item></paragraph> -<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> +<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_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> <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 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> +<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> +<paragraph id="par_id220502883332563" role="paragraph"><item type="input">=MINIFS(C2:C6;A2:A6;".*book";B2:B6;">"&MIN(B2:B6))</item></paragraph> +<paragraph id="par_id15342189586295" role="paragraph">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> -<paragraph id="par_id30574750215839" role="paragraph" xml-lang="en-US">If E2 = "book", the function returns 180, because the reference to the cell is substituted with its content.</paragraph> +<paragraph id="par_id50762995519951" role="paragraph">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"><item type="input">=MINIFS(C2:C6;A2:A6;".*"&E2;B2:B6;"<"&MAX(B2:B6))</item></paragraph> +<paragraph id="par_id30574750215839" role="paragraph">If E2 = "book", the function returns 180, because the reference to the cell is substituted with its content.</paragraph> <embed href="text/scalc/06/calcsamplefiles.xhp#func_ifs"/> <embed href="text/scalc/01/common_func.xhp#sectiontechinfo"/> <embed href="text/scalc/00/avail_release.xhp#5.2"/> @@ -59,13 +60,13 @@ <paragraph role="paragraph" id="par_id341640873986703" localize="false"><literal>COM.MICROSOFT.MINIFS</literal></paragraph> <section id="relatedtopics"> <tip id="par_id941677015454359"><link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/MINIFS">MINIFS wiki page</link>.</tip> -<paragraph id="par_id11921178730928" role="paragraph" xml-lang="en-US" localize="false"> +<paragraph id="par_id11921178730928" role="paragraph" localize="false"> <embedvar href="text/scalc/01/04060184.xhp#max_head"/>, <embedvar href="text/scalc/01/04060184.xhp#maxa_head"/>, <embedvar href="text/scalc/01/04060184.xhp#min_head"/>, <embedvar href="text/scalc/01/04060184.xhp#mina_head"/>, </paragraph> -<paragraph id="par_id11931178730928" role="paragraph" xml-lang="en-US" localize="false"> +<paragraph id="par_id11931178730928" role="paragraph" localize="false"> <embedvar href="text/scalc/01/func_countifs.xhp#countifs_head"/>, <embedvar href="text/scalc/01/func_minifs.xhp#minifs_head"/>, <embedvar href="text/scalc/01/func_maxifs.xhp#maxifs_head"/>, @@ -73,7 +74,7 @@ <embedvar href="text/scalc/01/func_sumifs.xhp#sumifs_head"/> </paragraph> -<paragraph id="par_id15970172625152" role="paragraph" localize="false" xml-lang="en-US"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> +<paragraph id="par_id15970172625152" role="paragraph" localize="false"><embedvar href="text/shared/01/02100001.xhp#02100001"/></paragraph> </section> </body> </helpdocument> |