writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
no edit summary
<div style="font-size:30px">'''MAXIF (Array,Condition,SumArray)'''</div><br/>
<div style="font-size:30px">'''MINIF (Array,Condition,SumArray)'''</div><br/>
*<math>Array</math> is the set of values.
*<math>Array</math> is the set of values.
*<math>Condition</math> is the particular condition value.
*<math>Condition</math> is the particular condition value.
==Description==
*This function shows the smallest value of the given set which satisfies the given condition.
*In <math>MINIF(Array,Condition,SumArray)</math>,<math>Array</math> is the set of values.
*<math>Condition</math> 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 [[Manuals/calci/MINA | MINA ]] function.
==Examples==
#MINIF([12,87,13,10,9,13],">10") = 13
#MINIF([15,19,20,25,27,17,32],"<20") = 17
#MINIF([1.001,1.1,1.02,1.06,1.005,1.08,2.3],"<1.06") = 1.005
==See Also==
*[[Manuals/calci/MINA | MINA ]]
*[[Manuals/calci/MIN | MIN ]]
*[[Manuals/calci/MAX | MAX ]]
==References==
[http://en.wikipedia.org/wiki/Minimum Minimum]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]