{"id":3465,"date":"2014-03-04T16:12:05","date_gmt":"2014-03-04T10:42:05","guid":{"rendered":"http:\/\/trumpexcel.com\/?page_id=3465"},"modified":"2023-09-29T15:21:55","modified_gmt":"2023-09-29T09:51:55","slug":"excel-min-function","status":"publish","type":"post","link":"https:\/\/trumpexcel.com\/excel-min-function\/","title":{"rendered":"How to Use Excel MIN Function (Examples + Video)"},"content":{"rendered":"

Excel MIN Function (Example + Video)<\/span><\/h2>\n

\"Excel<\/p>\n

When to use Excel MIN Function<\/span><\/h3>\n

MIN function can be used when you want to get the smallest value from a set of values.<\/p>\n

What it Returns<\/span><\/h3>\n

It returns the smallest value from a set of values.<\/p>\n

Syntax<\/span><\/h3>\n

=MIN(number1, [number2], …)<\/p>\n

Input Arguments<\/span><\/h3>\n
    \n
  • number1 – <\/b>the\u00a0first\u00a0number from a set of values from which you want to get the minimum value.<\/li>\n
  • [number2], ..<\/strong> – (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.<\/li>\n<\/ul>\n

    Additional Notes<\/span><\/h3>\n
      \n
    • Empty cells, logical values, or text in the array or reference are ignored.<\/li>\n
    • Arguments that are error values or text that cannot be translated into numbers cause errors.<\/li>\n
    • Arguments can either be numbers or names, arrays, or references that contain numbers.<\/li>\n
    • Logical values and text representations of numbers that you type directly into the list of arguments are counted.<\/li>\n
    • 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.<\/li>\n
    • If the arguments contain no numbers, MIN returns 0 (zero).<\/li>\n<\/ul>\n

      Excel MIN Function – Live Example<\/span><\/span><\/h2>\n