In Excel, you can use **MINA function** to find the smallest number in a set of numbers when you want to include logical values and text information representing numbers in a reference in the calculation. Please refer to MIN function if you do not want to include them.

**Formula:**

= MINA(number1, [number2], …)

**Explanations:**

– Number 1 is required;

– [number2] … numbers other than the first are optional.

**Cautions:**

– When a cell contains errors or information that can not be translated into numbers, the MINA function may return to errors.

– Blank cells are ignored.

– The logical values will be translated into 1 when they are TRUE values and 0 when they are FALSE values.

**Example 1:** What is the minimum income in Column C?

= MINA(C2:C9) The minimum income is 1.

**Example 2:** The MIN function vs. the MINA function

= MINA(C2:C9) The minimum value is 1.

= MIN(C2:C9) The minimum value is $53,308.

In this example, cell C6 is ignored because it is a blank cell. Cell C8 is translated into 1 because it is a logical value where value TRUE is translated into 1. The MINA function includes the logical value while the MIN function does not include the logical value.