Function MIN()

 

Description
Returns the minimum value from an array of numbers or dates.

Syntax

MIN(values)

Parameters

• values – An array of numbers or dates

Return Value
NUMBER or DATE

 

Examples

Formula

MIN([1,2,3,4,5,6])

Result
1

Formula

MIN([DATE(2019,01,01), DATE(2019,01,02)])

Result
01 Jan 2019

Notes

• Works with numeric and date arrays only
• Returns the lowest value in the array