Excel FunctionsLesson 97Free preview
MIN
This lesson is part of Excel · All levels
Summary
MIN is an Excel statistical function that returns the smallest value of a set of numbers or ranges. The syntax is. Text, logic, and empty cells are ignored so that the result is the smallest number.
Key points
- Syntax: MIN(number1, [number2], ...)
- Empty cells and text are ignored when counting
- If there are no numbers at all, the result of MIN is 0.
- The MINIFS variants calculate the minimum value based on the criteria
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.