3.5.2.31 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")=;

See Also

Countif, Maxifs