How to Use Excel MIN Function in Office 365? – [with Examples]
Tags: excelfunctions, excelminfunctioninof
Published: 2020-09-04 12:23:32

---
title: How to Use Excel MIN Function in Office 365? – [with Examples]
published: true
date: 2020-09-04 06:55:06 UTC
tags: ExcelFunctions,ExcelMINFunctioninOf
canonical_url: https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/
---

## Excel MIN Function:

![MIN Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/MIN-Function.png)<figcaption id="caption-attachment-13330">MIN Function</figcaption>

In this tutorial, we will guide you to learn how to use **Excel MIN Function in Office 365** with its syntax, explanation, and examples. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)



## **MIN Function – Explanation:**

- MIN Function **returns the smallest numeric value from the range of input values**.
- This function ignores **empty cells** , **text values** , and the logical values **TRUE & FALSE**.

## **Syntax:**

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

### Parameters Description:

**number1 ** – The first input number, or reference, or a range.

**number2 ** – It is an optional one. It could be a number, or reference, or a range that contains numeric values.

### Note:

- This function accept up to **255** arguments only.
- If the arguments contain **no numbers** and then it returns **0**.
- This function **ignores** logical values such as **TRUE & FALSE** , **text values** , and **empty cells**.

## **Examples:**

Let’s see some examples below.

### Example 1:

- Kindly, refer to the below example.
- You can see the input range is given in **Column B** , and the **MIN value** is found in the **cell D2**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-17.png)<figcaption id="caption-attachment-13327">Example 1</figcaption>

### Example 2:

- If the arguments contain **no numbers** and then it returns **0**.
- This function ignores logical values such as **TRUE & FALSE** , **text values** , and **empty cells**.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-14.png)<figcaption id="caption-attachment-13328">Example 2</figcaption>

## **Wrap-Up:**

In this tutorial, we helped you to understand the usage of **Excel MIN Function in Office 365** with its syntax, explanation, and examples. Leave your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

- [**MAXA Function**](https://geekexcel.com/how-to-use-excel-maxa-function-in-office-365-with-examples/)
- [**MAX Function**](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)
- **MINA Function**

### See Also:

- [How to Use Excel COSH Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-cosh-function-in-office-365-with-examples/)
- [How to Use Excel COUNTA Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-counta-function-in-office-365-with-examples/)