MAXIFS: Basic MAXIFS function from excel

In ExcelFunctionsR: Imports Excel Functions to R

Description

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

Usage

MAXIFS(
  max_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

max_range	Range from where it should return the maximum value 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 maximum value of Petal Length of species setosa who have petal width 0.2. Function will always return numeric class.

Examples

MAXIFS(iris$Petal.Length,iris$Species,"setosa",iris$Petal.Width,0.2)

Example output

[1] 1.9
Warning message:
In MAXIFS(iris$Petal.Length, iris$Species, "setosa", iris$Petal.Width,  :
  NAs introduced by coercion

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