Talk:Documentation/Calc Functions/MINIFS
SF comments
- (1) Summary. Change “meets” to “meet”.
- (2) Returns. Suggest replacing with “Returns a real value which is the minimum 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 minimum 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 5th row does satisfy the criterion (as do the 2nd and 4th rows).
- (8) Examples, simple usage, 2nd example. Maybe add a note to state that only the 4th row satisfies both criteria.
- (9) Examples, Using regular expressions and nested functions, 1st example. In the second sentence, the 2nd and 4th rows both satisfy the criteria.
- (10) Examples, Using regular expressions and nested functions, 2nd example. The text “except its minimum” is not correct – the condition as written does not rule out any value!
- (11) 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-27T17:01:02 (UTC)
Ronnie
all points addressed.
--Ronnie rg8888 (talk) 2020-11-27T12:46:08 (UTC)