Statistical
MINA Function in Excel
Returns the smallest value in a list of arguments, including text and logical values. Text and FALSE = 0, TRUE = 1.
Syntax
- =MINA(value1, [value2], ...)
Arguments
- value1 (required): First value or range
- value2 (optional): Additional values or ranges
Examples
- =MINA(1, 2, FALSE) - Min with FALSE (=0) - Result: 0
- =MINA(5, 10, "text") - Min with text (=0) - Result: 0
MINA for data analysis
- Confirm whether you need entire columns, filtered subsets, or distinct values.
- Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
- Pivot tables complement single-cell statistical formulas for exploration.
Common errors
- Text evaluates to 0, not ignored like in MIN
Use cases
- Finding minimum including logical values
- Mixed data analysis
Frequently asked questions
- What is the MINA function in Excel? MINA returns the smallest value in a list of arguments, including text and logical values. Text and FALSE = 0, TRUE = 1. The syntax is =MINA(value1, [value2], ...). Typical use cases include finding minimum including logical values, mixed data analysis.
- How do I use the MINA function? To use MINA, type =MINA( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
- What type of data does MINA work with? MINA works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
- Why is MINA not working in my Excel? Common issues with MINA include Text evaluates to 0, not ignored like in MIN. Start by checking the syntax =MINA(value1, [value2], ...), then verify each referenced cell or range.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.