MINIF: Basic MINIF function from excel

Description Usage Arguments Value Examples

View source: R/MINIF.R

Description

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

Usage

1
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

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

ExcelFunctionsR documentation built on July 1, 2020, 8:35 p.m.