MAXIFS (PQL - xl)

This function returns the largest value in a list of arguments, including text and logical values

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

Syntax

MAXIFS(max range, criteria range, criteria)

Function Arguments

Name

Description

Type

Optional

max range

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

StringOrNumber

criteria range

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

StringOrNumber

criteria

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

StringOrNumber

Comments

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