=MIN
The MIN function returns the smallest numeric value from a list of numbers separated by semicolons.
Syntax
Section titled “Syntax”=MIN(Parameter1; Parameter2; Parameter3; ...)Parameters
Section titled “Parameters”- Parameter1, Parameter2, Parameter3, … – The numeric values or field tokens to evaluate.
How It Works
Section titled “How It Works”-
Evaluates each numeric value provided.
-
Compares all values in the list.
-
Returns the lowest number found.
Usage Notes
Section titled “Usage Notes”-
Formula functions are case sensitive and must be written in ALL CAPS.
-
All parameters must be numeric; text values will cause errors or unexpected results.
-
Field tokens containing numbers can be used instead of hard-coded values.
-
Useful for identifying minimums such as lowest price, smallest quantity, or earliest score.
-
You can include multiple values in the function as long as the syntax remains valid.
Example
Section titled “Example”=MIN(15; 7; 27; 10)Returns: 7
Keywords
Section titled “Keywords”MIN, minimum value, numeric comparison, list of numbers, workflow formulas, formula function