Talk:Documentation/Calc Functions/MAXIFS

SF comments

 * (1) Summary. Change “meets” to “meet”.
 * (2) Returns. Suggest replacing with “Returns a real value which is the maximum value contained in cells of the specified ranges meeting their corresponding criteria.”.
 * (3) Arguments, 3rd bullet. Should “qualifies the Criterion” be replaced by “satisfies its criterion”?
 * (4) Arguments, bullets. Are cells within Range 1 … Range 255 that contain text (and satisfy their associated criterion) ignored when calculating the maximum value?
 * (5) Arguments, general. I think only one error condition is mentioned, i.e. Func_Range and Range 1, Range 2, etc not having the same size. Are there any other obvious error conditions?
 * (6) Additional details, 1st paragraph. In the text “regular expression on and off”, “expression” should be plural.
 * (7) Examples, simple usage, 1st example. Something wrong here, the maximum vale that is less than 35 must be 20. Please review and revise.
 * (8) Examples, Using regular expressions and nested functions, 1st example. Does the second row not satisfy the criteria too?
 * (9) Examples, Using regular expressions and nested functions, 2nd example. The text “except its maximum” is not correct – the condition as written does not rule out the maximum value. Also, with the condition as written, both the second and third rows meet the criteria.
 * (10) Examples, Reference to a cell as a criterion. This example only works if regular expressions are enabled. The previous example had wildcards enabled, which may cause confusion unless a statement is made.

--Stevefanning (talk) 2020-10-26T20:17:36 (UTC)