https://bugs.documentfoundation.org/show_bug.cgi?id=172035
Bug ID: 172035
Summary: DOCU error re: MINIFS
Product: LibreOffice
Version: 26.2.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
In Help
https://help.libreoffice.org/latest/en-US/text/scalc/01/func_minifs.html
are examples. Below the example table, there are the following examples for
usage:
#############
=MINIFS(B2:B6;B2:B6;"<35")
Calculates the minimum of values of the range B2:B6 that are lower than or
equal to 20. Returns 17.
=MINIFS(C2:C6;B2:B6;">=20";C2:C6;">90")
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.
#############
IMHO, the first refers to "lower than 35", and the second one is using "GREATER
than 90", when I look at the formula compared to the explanation.
--
You are receiving this mail because:
You are the assignee for the bug.
