Let’s look at the syntax (MIN and MAX use the same syntax)…
‘=MIN(number1, [number2], …)’
The function has one required argument, ‘number1’.
All later arguments are optional.
Did you know: Excel shows optional arguments in square brackets (such as above)
Look at this example of the ‘MIN’ function.
The result of this example would be ‘1’.
If we replace the ‘MIN’ with ‘MAX’ we would get ‘5’ as our result.
As you can see this is a pretty simple concept…
When sorting your values in an array isn’t a good option, ‘MIN’ and ‘MAX’ can help.
The purpose of the previous example was to show the simplicity of using these functions.