Manuals/calci/MINIF

MINIF (Array,Condition,SumArray)

• $Array$ is the set of values.
• $Condition$ is the particular condition value.

Description

• This function shows the smallest value of the given set which satisfies the given condition.
• In $MINIF(Array,Condition,SumArray)$,$Array$ is the set of values.
• $Condition$ 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

1. MINIF([12,87,13,10,9,13],">10") = 13
2. MINIF([15,19,20,25,27,17,32],"<20") = 17
3. MINIF([1.001,1.1,1.02,1.06,1.005,1.08,2.3],"<1.06") = 1.005

Related Videos

MinIf

See Also

• MINA
• MIN
• MAX

References

Minimum

• List of Main Z Functions
• Z3 home