MINA

• How to use MINA formula?
• Examples of using MINA formula
• MINA formula not working?
• Similar formulas to MINA

Usage

Use the MINA formula with the syntax shown below, it has 2 required parameters:

=MINA(value1, value2)

1. value1 (required):
   The first cell or range of cells to consider when finding the smallest value.
2. value2 (required):
   An optional second cell or range of cells to consider when finding the smallest value.

Examples

Finding the minimum value in a range

You can use MINA to find the smallest value in a range of cells, including numbers, dates, and times. This is useful for finding the minimum value in a dataset.

Finding the smallest non-zero value in a range

If you need to find the smallest non-zero value in a range, you can use MINA with the FILTER function. For example, =MINA(FILTER(A1:A10,A1:A10<>0)) will return the smallest non-zero value in cells A1 to A10.

Finding the smallest value between two ranges

You can use MINA with two ranges of cells to find the smallest value between them. For example, =MINA(A1:A10,B1:B10) will return the smallest value in cells A1 to A10 and B1 to B10.

Common Mistakes

Not providing any values

When using MINA, you need to provide at least one value to compare. If you provide no values, the formula will return an error. To fix this, add at least one value to the formula.

Providing non-numeric values

MINA can only compare numeric values. If you provide non-numeric values, the formula will return an error. To fix this, make sure all values provided to the formula are numeric.

Providing a range of cells

MINA can only compare individual values. If you provide a range of cells to the formula, it will return an error. To fix this, provide individual values to the formula.

Using MINA with other statistical functions

MINA is used to find the smallest value among a group of values. It should not be used in conjunction with other statistical functions like AVERAGE or COUNT. If you need to use multiple statistical functions, use them separately.

Related Formulas

The following functions are similar to MINA or are often used with it in a formula:

• MIN

  The MIN formula is a statistical function that returns the smallest value in a set of numbers. It is commonly used to find the minimum value from a range of cells or a list of values.

• MAXA

  The MAXA function returns the maximum value in a range of values or an array, including text or logical values. It evaluates each value as numeric data. If a cell in the range or array contains text or logical values, it is ignored. If all cells in the range or array contain text or logical values, the MAXA function returns 0. This function is useful for finding the highest value in a set of numbers or values.

• AVERAGE

  The AVERAGE function calculates the average (arithmetic mean) of the values passed to it. It is commonly used to find the average of a range of cells containing numerical data.

• MEDIAN

  The MEDIAN function returns the median (middle) value of a set of numbers. It is commonly used to find the middle value in a range of data points. If the number of data points is even, it returns the average of the two middle values. This function can be useful in statistical analysis and data visualization.

• MODE

  The MODE formula in Google Sheets returns the most frequently occurring value in a dataset. It is commonly used in statistical analysis to identify the value that occurs most frequently in a set of data. The formula requires at least one input value, but can accept multiple values to include in the analysis.

Learn More

You can learn more about the MINA Google Sheets function on Google Support.