How to Use the MINA Function in Google Sheets

Published on

MINA is a statistical function in Google Sheets used to find the minimum value in a range. It differs from the MIN function. After discussing the syntax and providing a few examples, we will explore a real-life application of the MINA function in Google Sheets.

Syntax:

MINA(value1, [value2, …])

Arguments:

  • value1, value2, …: These are the values or ranges to consider.

Example:

=MINA(1, 5, 4, 0)

In this example, we have used four values, and the formula will return 0 as the lowest value among them.

If these values are in A1, A2, A3, and A4, you can use:

=MINA(A1, A2, A3, A4)

or

=MINA(A1:A4)

In the latter case, we have specified the argument as a range.

How the MINA Function Differs from the MIN Function

Both the MIN and MINA functions return the smallest values from a set of values. While the former considers only numerical values in the dataset, the latter considers all values.

If the set of values contains the boolean values TRUE or FALSE, the MINA function treats them as 1 and 0, respectively. It considers text values as 0.

Therefore, the output may differ when you apply both the MIN and MINA functions in a mixed data type column.

In the following example, the range B3:B12 contains numbers in all cells except B5, which contains the boolean value TRUE.

Thus, the following MINA formula in cell D3 returns 1 as the minimum value:

=MINA(B3:B13)
Example of Using the MINA Function in Google Sheets

Practical Example of the MINA Function in Google Sheets

We have sales targets and actual sales in a range. Let’s test whether we meet the sales targets.

The sales targets are in B2:B5, and the actual sales are in C2:C5. The following formula will evaluate and return the status.

=IF(
   MINA(ArrayFormula(C2:C5 >= B2:B5)) = 1, 
   "Target Achieved", 
   "Target Not Achieved"
)
Handling Boolean Values and Text in the MINA Function

Formula Breakdown

The following logical part returns an array of TRUE or FALSE, where TRUE indicates that the target is met and FALSE indicates that it is not met:

=ArrayFormula(C2:C5 >= B2:B5)
true or false array result for MINA test

We apply the MINA function to this array with:

=MINA(ArrayFormula(C2:C5 >= B2:B5))

If the output of MINA is 1, it means that all targets are met; otherwise, they are not met.

We use the IF logical test to return “Target Achieved” if the output of MINA is 1 and “Target Not Achieved” if it is 0.

Resources

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Expert Prashanth KV is a Diamond Product Expert in Google Sheets, officially recognized by Google for his contributions to the Docs Editors Help Community and featured in the Google Product Experts Directory. Explore his blog to learn advanced formulas, automation tips, and problem-solving techniques to elevate your spreadsheet skills.

Calculate Trip Days by Month (Start, End, and Full Days) in Google Sheets

If you're managing business travel in Google Sheets, you may need to calculate how...

Mode of Comma-Separated Numbers in Excel (Dynamic Array)

There is no dedicated function in Excel to directly find the mode of comma-separated...

How to Find Mode of Comma-Separated Numbers in Google Sheets

Working with comma-separated numbers inside a single cell is a common scenario in Google...

How to Count Merged Cells in Google Sheets (and Get Their Size)

Sometimes, you may have blocks of merged cells in a column or row. But...

More like this

Calculate Trip Days by Month (Start, End, and Full Days) in Google Sheets

If you're managing business travel in Google Sheets, you may need to calculate how...

How to Find Mode of Comma-Separated Numbers in Google Sheets

Working with comma-separated numbers inside a single cell is a common scenario in Google...

How to Count Merged Cells in Google Sheets (and Get Their Size)

Sometimes, you may have blocks of merged cells in a column or row. But...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.