The MIN function returns the smallest value in a range. The MAX function returns the largest value in a range.

Simplified syntax:

=MIN(range)
=MAX(range)

• If the arguments contain no numbers, MIN or MAX will returns 0.
• Arguments that are error values or text that cannot be translated into numbers cause errors.
• If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MINA function.

Useful tricks:

• When a range is select the =SUM is displayed at the bottom of the screen. Right click on the Sum and then select Minimum/Maximum
• Enter the =SUM using the AutoSum feature where you want to enter the =MIN or =MAX. This saves from typing and selecting the desired range. Then, in the Edit mode, double click the SUM to highlight it then type either MIN or MAX

The technical syntax:

This is the Syntax as presented by Excel. The Simplified Syntax at the top of the page is the “English” version of the Syntax.