How To Use Excel MIN Function – Quick Guide

Given a set of sales data, you might want to find the least sales figure.

Let us see how to use it in detail…

1. What is the MIN Function?
2. What is the Syntax?
3. How to use it with an example?


1. What is the MIN Function?

The MIN function can be used to get the minimum value from a range of values.


2. What is the Syntax?

=MIN(value1,value2,value3…)

  • value1   =  A number, range,expression or a cell reference.
  • value2,value3…  =  Optional, it can be a numbercell reference, expression or range.

Note :

  • If a reference to a cell, or an array of cells are directly supplied to the Min function will ignore blank cells, and text or logical values contained within the supplied cell range.
  • However, the text representations of numbers that are supplied directly to the function will be included in the calculation.
  • I the range provided or cell referencing it contains error then it causes an error.

3. How to use it with an example?

Assuming we have a column with some data in it
Let’s quickly find the MIN of the given range…

=MIN(B2:B8)

Excel Min function.PNG

Few other possible operations…

=MIN(A2,A8) // Returns the minimum number from the given references
=MIN(A2,-3,"2") // Returns the minimum number from the arguments
Advertisements

Author: Sharath Raju

Founder@www.ExcelCult.com

Leave a Reply