=MAX
The MAX function returns the largest numeric value from a list of numbers separated by semicolons.
Syntax
Section titled “Syntax”=MAX(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 highest 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; if any value is not numeric, the function returns an empty result.
-
Field tokens containing numbers can be used instead of hard-coded values.
-
Useful for finding maximum values such as highest cost, largest quantity, or latest score.
-
You can include as many parameters as needed - there is no fixed limit as long as syntax is valid.
Example
Section titled “Example”=MAX(15; 6; 27; 10)Returns: 27
Keywords
Section titled “Keywords”MAX, maximum value, numeric comparison, list of numbers, workflow formulas, Boolean logic, formula function