# MINIFS: Basic MINIFS function from excel In ExcelFunctionsR: Imports Excel Functions to R

## Description

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

## Usage

 ``` 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23``` ```MINIFS( min_range, criteria_range1, criteria1, criteria_range2 = TRUE, criteria2 = TRUE, criteria_range3 = TRUE, criteria3 = TRUE, criteria_range4 = TRUE, criteria4 = TRUE, criteria_range5 = TRUE, criteria5 = TRUE, criteria_range6 = TRUE, criteria6 = TRUE, criteria_range7 = TRUE, criteria7 = TRUE, criteria_range8 = TRUE, criteria8 = TRUE, criteria_range9 = TRUE, criteria9 = TRUE, criteria_range10 = TRUE, criteria10 = TRUE ) ```

## Arguments

 `min_range` From which range should it return the minimum from? `criteria_range1, criteria_range2, criteria_range3, criteria_range4, criteria_range5, criteria_range6, criteria_range7, criteria_range8, criteria_range9, criteria_range10` Which range should the criteria tested for.Only criteria_range1 is mandatory,others are optional. `criteria1, criteria2, criteria3, criteria4, criteria5, criteria6, criteria7, criteria8, criteria9, criteria10` What criteria should the range be checked against. Only criteria1 is mandatory, others are optional.

## Value

This example returns minimum value of Petal Length of species setosa who have petal width 0.2. Function will always return numeric class.

## Examples

 `1` ```MINIFS(iris\$Petal.Length,iris\$Species,"setosa",iris\$Petal.Width,0.2) ```

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