Hi All,
*file: func_minifs.xhp*
- while in context - func_minifs.xhp\n par_id220502883332563\n help.text
it reads "book":
<item type="input">=MINIFS(C2:C6;A2:A6;".*book";B2:B6;"<="
&MAX(B2:B6))</item>
- in context - func_minifs.xhp\n par_id15342189586295\n help.text
it reads "pen":
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.
- and in context - func_minifs.xhp\n par_id30574750215839\n help.text
it reads again "book":
If E2 = "book", the function returns 180, because the reference to the
cell is substituted with its content.
Can we safely change "pen" > "book"?
TIA and Ciao,