MinIf

Description of formula:
Finds the smallest value of the elements from the specified range, which meet the criteria.
First parameter is an array of values, to which the condition is applied. If some element satisfies the condition, corresponding value from result_values array is taken into account in finding minimal value. Both arrays must have the same number of elements. The third parameter of the formula is optional – if you do not specify it, values from query_values array will be used both for checking the condition and for finding the smallest element.
The condition is an expression, which returns a logical value (true / false). You can use there any formula, comparison operator and join several criteria with and and or. Use value keyword to refer to evaluated element from the query_values array.
Syntax:
minif(query_values, condition, [result_values])
Parameters:
query_values
(type: array of values of any type) Values to which the condition is applied
condition
(type: Logical value) Logical expression, defining which elements will be used for calculations
result_values
(type: array of Numbers) (optional parameter) Elements to find minimal value (if you want to use another values than passed in the first parameter)
Returned type:
Number
Examples:
=minif(A1:A5,value>100)
=minif(A1:A5, value>100, B1:B5)
=minif(section1.B, value=’product1’, section1.A)
=minif(A, abs(value)/2>section1.A1, C)
=minif(A, value>20 and value<50)
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk