Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Excel Advanced Lookup using Index and Match Functions
  • How to use Excel VLOOKUP Function
  • How to reference named range different sheet in Excel
  • Approximate match with multiple criteria in Excel
  • How to get last column number in range in Excel

Data Analysis Examples

  • How to Create Gantt Chart in Excel
  • Subtotal function in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • Example of COUNTIFS with variable table column in Excel
  • Move chart to a separate worksheet in Excel

Data Validation Examples

  • Excel Data validation number multiple 100
  • Prevent invalid data entering in specific cells
  • Excel Data validation must not contain
  • Excel Data validation must contain specific text
  • Excel Data validation whole percentage only

MIN function: Description, Usage, Syntax, Examples and Explanation

by

 What is MIN function in Excel?

MIN function is one of Statistical functions in Microsoft Excel that returns the smallest number in a set of values.

Syntax of MIN function

MIN(number1, [number2], …)

The MIN function syntax has the following arguments:

  • Number1, number2, …    Number1 is optional, subsequent numbers are optional. 1 to 255 numbers for which you want to find the minimum value.

Explanation of MIN function

  • 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.
  • Arguments that are error values or text that cannot be translated into numbers cause errors.
  • If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the MINA function.
Worked Example:   Smaller of two values in Excel

Example of MIN function

Steps to follow:

Worked Example:   How to get relative row numbers in a range in Excel

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Worked Example:   Minimum value in Excel

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

You can adjust the column widths to see all the data, if need be.

9 Mathematical Computations Example using Excel Statistical Function

Data
10
7
9
27
2
Formula Description Result
=MIN(A2:A6) Smallest of the numbers in the range A2:A6. 2
=MIN(A2:A6,0) Smallest of the numbers in the range A2:A6 and 0.

Post navigation

Previous Post:

MAXIFS function: Description, Usage, Syntax, Examples and Explanation

Next Post:

MEDIAN function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • FIXED function: Description, Usage, Syntax, Examples and Explanation
  • Extract middle name from full name — Manipulating NAMES in Excel
  • How to extract nth word from text string in excel
  • FIND, FINDB functions: Description, Usage, Syntax, Examples and Explanation
  • ASC function: Description, Usage, Syntax, Examples and Explanation
  • Get first day of month in Excel
  • NETWORKDAYS function: Description, Usage, Syntax, Examples and Explanation
  • Get days between dates ignoring years in Excel
  • Convert Excel time to decimal hours in Excel
  • NOW function: Description, Usage, Syntax, Examples and Explanation
  • VDB function: Description, Usage, Syntax, Examples and Explanation
  • Future value vs. Present value examples in Excel
  • ACCRINTM function: Description, Usage, Syntax, Examples and Explanation
  • XNPV function: Description, Usage, Syntax, Examples and Explanation
  • RATE function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles