Minifs
Description
Minimum Origin Version Required: 2019 SR0
This function returns the minimum value from a given dataset vd that satisfies a specified condition con.
Syntax
double Minifs(vector vd, string con$)
Parameters
vd
- A dataset or specified column in Origin worksheet from which the minimum value is found.
con
- the condition you use to find a sub-range within vd. It can be an expression and must be inclosed by double quotation ("").
Return
Return the minimum value from a set of values that satisfies a specified condition.
Example
col(A) = data(1,32); minifs(col(A),"col(A) > 5 && col(A) < 10")=; // Return 6
//simpler condition minifs(col(A), ">5")=;