Manuals/calci/MINIF
MINIF (Array,Condition,SumArray)
- is the set of values.
- is the particular condition value.
Description
- This function shows the smallest value of the given set which satisfies the given condition.
- In , is the set of values.
- is the particular condition which satisfies the minimum value.
- The given array can be numbers, names, arrays or references that contain numbers.
- Also logical values and text representation can be valid when we are entering directly.
- In a referred array only numbers are considered.
- Empty cells,logical values or text in the referred array are not considered.
- Suppose the array values contain no numbers then this gives the value as 0.
- This function will return the result as error when any one of the argument is non-numeric or the referred array cannot translated in to numbers.
- suppose we want to consider the logical values in a referred array , we can include in the MINA function.
Examples
- MINIF([12,87,13,10,9,13],">10") = 12
- MINIF([15,19,20,25,27,17,32],"<20") = 15
- MINIF([1.001,1.1,1.02,1.06,1.005,1.08,2.3],"<1.06") = 1.001
Related Videos
See Also
References