How to Use Excel MIN Function (Examples + Video)

Excel MIN Function (Example + Video)

Excel MIN Function

When to use Excel MIN Function

MIN function can be used when you want to get the smallest value from a set of values.

What it Returns

It returns the smallest value from a set of values.

Syntax

=MIN(number1, [number2], …)

Input Arguments

  • number1 – the first number from a set of values from which you want to get the minimum value.
  • [number2], .. – (optional) second number from a set of values from which you want to get the minimum value. Up to 255 arguments can be used in the MIN function.

Additional Notes

  • Empty cells, logical values, or text in the array or reference are ignored.
  • Arguments that are error values or text that cannot be translated into numbers cause errors.
  • Arguments can either be numbers or names, arrays, or references that contain numbers.
  • Logical values and text representations of numbers that you type directly into the list of arguments are counted.
  • If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored.
  • If the arguments contain no numbers, MIN returns 0 (zero).

Excel MIN Function – Live Example

Excel MIN Function – Video Tutorial

Related Excel Functions:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Picture of Sumit Bansal
Hey! I'm Sumit Bansal, founder of TrumpExcel.com and a Microsoft Excel MVP. I started this site in 2013 because I genuinely love Microsoft Excel (yes, really!) and wanted to share that passion through easy Excel tutorials, tips, and Excel training videos. My goal is straightforward: help you master Excel skills so you can work smarter, boost productivity, and maybe even enjoy spreadsheets along the way!

Leave a Comment

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster