Formulas > =MINA()

How To Use MINA() Function in Google Sheets


Returns the minimum numeric value in a dataset.

Common Questions about the MINA Formula:
1. What does the MINA formula do?
2. How do I use the MINA formula in Google Sheets?
3. What information does the MINA formula return?

How can the MINA Formula be Used Appropriately?
1. Use MINA to find the smallest numerical value in a group of numbers.
2. Use MINA to find the smallest value in a range of values.
3. Use MINA to find the minimum amount of value in a data set.

How can the MINA Formula be Commonly Mistyped?
1. Using parentheses instead of brackets ([]).
2. Typing “min” or “max” instead of “MINA”.
3. Mixing up arguments and using wrong argument order.

What are some Common Ways the MINA Formula is Used Inappropriately?
1. Use MINA to find the largest numerical value in a group of numbers.
2. Use MINA to compare non-numerical values.
3. Use MINA to compare values across different data sets.

What are Some Common Pitfalls when Using the MINA Formula?
1. Confusing the MINA function for the MIN function.
2. Failing to provide enough parameters to the MINA function.
3. Trying to include text characters in the parameters of the MINA formula.

What are Common Mistakes when Using the MINA Formula?
1. Setting parameters to blank cells or leaving them empty entirely.
2. Forgetting to include multiple parameters for the MINA formula.
3. Using incorrect formulas syntax or a wrong formula altogether.

What are Common Misconceptions People Might Have with the MINA Formula?
1. Thinking that MINA can be used to compare non-numerical values.
2. Believing that MINA will always return the same numerical value.
3. Thinking that MINA can compare values across multiple data sets.

How To Actually Use MINA() in Sheets

MINA(value1, value2)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the MINA() formula:

Mina function example in excel

This video shows you how to get smallest value using mina formula in MS Excel 2019 Office 365.

Generate a MINA() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.