MIN

Returns the minimum of numers in a range.

Syntax

MIN(range; orientation)

  • range - a range of values - Value type: range

  • orientation - the orientation of the minimum calculation - Value type: constant (optional, all as default). Possible values are:

    • all - the minimum of the whole range is returned as a single number

    • horizontal - the minimum calculation is performed horizontally (row-wise) and returned as a column of numbers

    • vertical - the minimum calculation is performed vertically (column-wise) and returned as a row of numbers

Remarks

  • Empty cells or cells which cannot be converted to numbers are ignored in the minimum calculation.

Examples