Apache POI - Common 5.3.0 · org.apache.poi.ss.formula.functions.Minifs

Implementation for the Excel function MINIFS

Syntax :

MINIFS ( min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

min_range Required. One or more cells to determine the minimum value of, including numbers or names, ranges, or cell references that contain numbers. Blank and text values are ignored.
criteria1_range Required. The first range in which to evaluate the associated criteria.
criteria1 Required. The criteria in the form of a number, expression, cell reference, or text that define which cells in the criteria_range1 argument will be added
criteria_range2, criteria2, ... Optional. Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed.

Modifier and Type	Field and Description
public static final FreeRefFunction	instance Singleton

Access	Constructor and Description
public	Minifs()

Method Summary

Modifier and Type	Method and Description
protected Baseifs.Aggregator	createAggregator() Implements abstract org.apache.poi.ss.formula.functions.Baseifs.createAggregator.
protected boolean	hasInitialRange() Implements abstract org.apache.poi.ss.formula.functions.Baseifs.hasInitialRange. https://support.microsoft.com/en-us/office/minifs-function-6ca1ddaa-079b-4e74-80cc-72eef32e6599 MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...

Inherited from org.apache.poi.ss.formula.functions.Baseifs:: convertRangeArg evaluate

Field Detail

instance	back to summary
public static final FreeRefFunction instance Singleton

Constructor Detail

Minifs	back to summary
public Minifs()

Method Detail

createAggregator	back to summary
protected Baseifs.Aggregator createAggregator() Implements abstract org.apache.poi.ss.formula.functions.Baseifs.createAggregator. Annotations @Override

createAggregator

back to summary

protected Baseifs.Aggregator createAggregator()

Implements abstract org.apache.poi.ss.formula.functions.Baseifs.createAggregator.

Annotations

@Override

hasInitialRange	back to summary
protected boolean hasInitialRange() Implements abstract org.apache.poi.ss.formula.functions.Baseifs.hasInitialRange. https://support.microsoft.com/en-us/office/minifs-function-6ca1ddaa-079b-4e74-80cc-72eef32e6599 MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ... need at least 3 arguments and need to have an odd number of arguments (min-range plus x*(criteria_range, criteria)) Returns:boolean Doc from org.apache.poi.ss.formula.functions.Baseifs.hasInitialRange. true if there should be a range argument before the criteria pairs Annotations @Override

hasInitialRange

back to summary

protected boolean hasInitialRange()

Implements abstract org.apache.poi.ss.formula.functions.Baseifs.hasInitialRange.

https://support.microsoft.com/en-us/office/minifs-function-6ca1ddaa-079b-4e74-80cc-72eef32e6599 MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ... need at least 3 arguments and need to have an odd number of arguments (min-range plus x*(criteria_range, criteria))

Returns:boolean

Doc from org.apache.poi.ss.formula.functions.Baseifs.hasInitialRange.

true if there should be a range argument before the criteria pairs

Annotations

@Override

public final Class Minifs

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail