ExcelFunctionsR (version 0.1.4)

MAXIF: Basic MAXIF function from excel

Description

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

Usage

MAXIF(range, criteria, max_range)

Arguments

range

Range where it should check the criteria

criteria

Where should it lookup the value

max_range

Which array should it return the max from.

Value

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

Examples

# NOT RUN {
MAXIF(iris$Species,"virginica",iris$Sepal.Length)
# }