MINIFS (PQL - xl)

This function returns the minimum value among the values in cells or the cell range provided the specified set of conditions or the criteria meets

  • Library: PQL \ Spreadsheet \ Statistical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

MINIFS(min range, criteria range, criteria)

Function Arguments

Name

Description

Type

Optional

min range

Refers to the range of cells in which minimum will be calculated

StringOrNumber

criteria range

Refers to the set of cells to be calculated based on criteria

StringOrNumber

criteria

Refers to the criteria (in term of number, expression, or text) according to which cells will be calculated

StringOrNumber

Comments

This function is the same as the Microsoft Excel 'MINIFS' function - using the same inputs, logic and outputs.