Formula Generator - MINA function
The MINA function is used to find the minimum numeric value in a dataset. It ignores any non-numeric values and treats them as zero. It is similar to the MIN function, but it can handle arrays and ranges as inputs.How to generate an MINA formula using AI.
To get the MINA formula from an AI chatbot, you could ask the following question: "What is the Excel formula to find the smallest non-zero value in a range of cells?"
MINA formula syntax.
The MINA function in Excel is used to find the minimum value in a range of cells, including numbers, text, and logical values. The syntax for MINA is: MINA(value1, [value2], ...) - value1: Required. The first value or range of cells to consider. - value2: Optional. Additional values or ranges to consider. The MINA function ignores any empty cells, text, or logical values in the range. It returns the smallest value found. Example: =MINA(A1:A5) - Finds the smallest value in the range A1 to A5, including any text or logical values. Note: If all the values in the range are text or logical values, MINA will return a #VALUE! error.
Finding the minimum value in a range
In this use case, we use the MINA function to find the minimum numeric value in a range of cells.
=MINA(A1:A10)
Finding the minimum value in a filtered dataset
In this use case, we use the MINA function to find the minimum numeric value in a dataset that meets certain criteria.
=MINA(IF(A1:A10>5, A1:A10))
Finding the minimum value in a dataset with errors
In this use case, we use the MINA function to find the minimum numeric value in a dataset that may contain errors.