MINIF {ExcelFunctionsR}

Basic MINIF function from excel

Description

It acts similiarly to Excel's MINIF function. It returns the minimum value from an array after testing for certain criterias.

Usage

MINIF(range, criteria, min_range)

Arguments

range

Which range should it check the criteria against?

criteria

What should be checked?

min_range

From which range should it return the minimum from?

Value

In this case we get the minimum value of Sepal Length from Species which are virginica. Function will always return numeric class.

Examples

MINIF(iris$Species,"virginica",iris$Sepal.Length)