Using the MIN Function in Excel: A Complete Guide

Rumman Ansari   Software Engineer   2024-08-03 03:01:39   141  Share
Subject Syllabus DetailsSubject Details
☰ TContent
☰Fullscreen

Table of Content:

MIN Function in Excel

The MIN function in Excel is a mathematical function that allows you to find the minimum value in a range of cells.

The syntax of the MIN function is as follows:


MIN(number1, [number2], ...)

where:

  • "number1" is the first number or range of cells from which you want to find the minimum value.
  • "[number2]" is an optional argument that represents additional numbers or ranges of cells from which you want to find the minimum value.

For example, if you have a range of cells containing some numbers, say A1:A5, and you want to find the minimum value in that range, you can use the following formula:


=MIN(A1:A5)

The result will be the smallest value in the range A1:A5.

The MIN function can be very useful when you need to find the smallest or minimum value in a range of data, such as finding the lowest sales figure for a particular product or the lowest score on a test.