Manuals/calci/MINIF

Revision as of 04:10, 13 August 2020 by Devika (talk | contribs) (→‎Examples)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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

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

Related Videos

MinIf

See Also

References

Minimum