The Excel MIN function returns the minimum value in an array or range of cells. In this guide, we’re going to show you how to use the MIN function and also throw in some tips and error handling methods.
- All Excel versions
Excel MIN Function Syntax
The first number or numbers where you want to find the minimum. You can enter a static number like 4, a cell reference like B6, or a cell range like B2:B8.
Optional. The subsequent number or numbers, up to 255 inputs.
- The Excel MIN function ignores string values. However, keep in mind that Excel executes date or time values as numbers, not strings.
- Use the MINIFS function to find the minimum number that meets specific conditions.
- The opposite of this function is the MAX function which returns the minimum number in an array.
If there is an error in referred cells or ranges, the MIN function returns the same error.