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

---
title: How to Use Excel MINA Function in Office 365? – [with Examples]
published: true
date: 2020-09-04 07:07:24 UTC
tags: ExcelFunctions,ExcelMINAFunctioninO
canonical_url: https://geekexcel.com/how-to-use-excel-mina-function-in-office-365-with-examples/
---

## Excel MINA Function:

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

Let’s see the usage of **Excel MINA Function in Office 365** with its syntax, explanation, and examples. 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)


## **MINA Function – Explanation:**

- This function **returns the smallest numeric value from the given range of values**.
- It is similar to **MIN Function** but the only difference is **MINA Function evaluates** the logical values **TRUE** and **FALSE** as **1** and **0**.

## **Syntax:**

**=MINA(value1, [value2],.)**

### Argument Description:

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

**value2 ** – 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 evaluates logical values **TRUE & FALSE** as **1** and **0**.
- It ignores the **empty cells**.

## **Examples:**

Here are the examples for your reference.

### Example 1:

- Please refer to the below image.
- You can see the input values are given in **Column A, B, C, and D**. The **MINA values** are listed in **Column E**.
- In the below image, the MINA function is calculated for the values from the cell “ **A2:D2** ” & “ **A3:D3** ” & “ **A4:D4** “.

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

### Example 2:

- If the arguments contain **no numbers** and then it returns **0**.
- In the below image, the MINA Function considers the **TRUE & FALSE** as **1** and **0**.

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

## **Wind-Up:**

In this article, you can grasp the usage of **Excel MINA Function in Office 365** with its syntax, explanation, and examples. Kindly, give your **suggestions** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Functions:

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

### Read Ahead:

- [How to Use Excel ACOS Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-acos-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/)